Google BigQuery extract string from column with regexp_extract

Question

I need to extract the app_id from the following string in the column below:

&app_id=4.25.9&

so anything that starts with &app_id= and ends with &

Any ideas on how to write this example? The number of characters and symbols may differ.

It looks like answer by @Sadiq should solve your issue. If that's the case accept it please. — VictorGGl
– VictorGGl, Commented Jul 9, 2018 at 8:12

Sadiq · Accepted Answer · 2018-07-06 10:43:26Z

4

This should be sufficient:

REGEXP_EXTRACT(your_column, r'\&app_id=(.+?)\&')

The app id matching right now .+? is a little broad and will match any character, you may want to restrict it further.

answered Jul 6, 2018 at 10:43

Sadiq

711 silver badge2 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1