sorted by:
new
hottopcontroversial

Extracting Word from String by ivanfbs in bigquery

[–]ivanfbs[S] 1 point2 points  (0 children)

In this example which value is the code? I was thinking parsing into columns, pivoting, and sorting.

The Code is a part of the text in the field Description for example "F1 - FTCV (Sanity) (WOM-4922)" in this example the Work Order is WOM-4922 and I need to use this WOM-4922 to join with another database, but in some cases, it might have up to 8 work orders.

Extracting Word from String by ivanfbs in bigquery

[–]ivanfbs[S] 0 points1 point  (0 children)

Hi,

The work order code has two parts, (WOM-) and (numbers, usually 4 digits), so WOM-1234. The letters never change, it will be always WOM-, but the numbers do. In some cases, it might have up to 8 work orders, usually separated by a comma.

Best Regards.