Hi!
I can't find solution, may be somebody can help me.
Example:

SELECT
'ABC123D666656-522815EF!@55#' AS COL1

I need to extract 666656-52281. But other string chartes can be different. Also can vary their number. I need XXXXXX-XXXXX (where X=[0-9]) from any kind of text.
I stoped on this step:

I have  a string which looks like 
"/channel/featured?page_id=this_is-the_text-that_I_want&rest_of_the_query"
I'm trying to extract just 'this_is-the_text-that_I_want',
I thought it might look like regexp_substr(field_text ,'(?<=/?page_id\=)(.*?)(?=\&)' ,1 ,1, 'i')
But I get a message saying this is not a pattern.

Hi All,
I am fairly new to Teradata 14 and want to use the Regular Expressions.
I have a column that has values as below.

Hi,
 
I am trying to call for REGEXP_INSTR , but despite being on :
InfoKey,InfoData
RELEASE,14.00.04.08
LANGUAGE SUPPORT MODE,Standard
VERSION,14.00.04.07
I am getting 5589 error telling that REGEXP_INSTR function does not exist?
fyi, REGEXP_SUBSTR is calle without trouble.