extracting string from URL using regex (on data studio)

Question

I have the following landing page

city7900/
cityid=7900
city7900-t40094705.nb1/

and I want to merge everything to

on data studio

I tried using

REGEXP_EXTRACT(Landing Page,'city([^&]+))

and it only extract the

city7900/
cityid=7900

ones and tried

REGEXP_EXTRACT(Landing Page,'city([^&]+)|city([^&]+)(.*?)\\-')

and it only extracts the city7900-t40094705.nb1/

how can I extract all of them?

Wiktor Stribiżew · Accepted Answer · 2020-12-31 15:17:33Z

2

You can use

REGEXP_EXTRACT(Landing Page,'city[^0-9]*([0-9]+)')

See the regex demo. Details:

answered Dec 31, 2020 at 15:17

Wiktor Stribiżew

631k41 gold badges502 silver badges633 bronze badges

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

1 Answer 1