i have to fetch model no. col data from ivm col. data.

CodePudding user response：

On BigQuery we can try using REGEXP_EXTRACT:

SELECT ivm, REGEXP_EXTRACT(ivm, r'(?:[^-] -){2}(.*)') AS model_no
FROM yourTable;

Here is an explanation of the regex pattern used:

(?:[^-] -){2}  match ABC123-DEF456- (i.e. first 2 terms)
(.*)           then capture everything else which follows

CodePudding user response：

Consider below approach (BigQuery) - I think in this option regexp is much easier to swallow :o) - it just looks for two groups of digits at the beginning and simply removes them - leaving exactly what you are looking for - which is the rest of string

select ivm, regexp_replace(ivm, r'^\d -\d -', '') as  model_no
from your_table    

if applied to sample data in your question - output is