regex in teradata, how to pass two values in

Question

I have the following regex which works, but I need to find this expression if shop_id also

   regexp_substr(field_text ,'(?<=\?page_id\=)(.*?)(?=\&)' ,1 ,1, 'i')

I tried this:

   regexp_substr(fullurl ,'(?<=(\?page_id\=|/page_id/))(.*?)(?=\&)' ,1 ,1, 'i')

But it states this is not a valid pattern, can someone please explain why not, as it works in regex sites.

Answer 1

You need to add round brackets for the alternative expression:

REGEXP_SUBSTR(fullurl ,'(?<=\?(page|shop)_id\=)(.*?)(?=\&)' ,1 ,1, 'i')