I have a list of URLs/ Here is an example — www.site.com/product/item1/?utm_source=google&utm_medium=cpc
How I can get all characters before question mark using BigQuery? Sо I want to get www.site.com/product/item1/ from this string.
Thanks a lot!
2 Answers
The easiest way I think is to use SPLIT function as in below example
SPLIT(url, '?')[OFFSET(0)]
As alternative, you can use REGEXP_EXTRACT as in below example
REGEXP_EXTRACT(url, r'[^?]*')
you can use the REGEXP_EXTRACT function. You will have to create the regexp expression though.
Furthermore, you could use Dataflow to transform the data as another option.
Related