I have a table which contains comments field against each material entry. I have to extract the numbers after the string "AVAR" that means
Material X - 'this product 123 AVAR0001256701 manufactured in AVAR0001256725'
I tried with following
Select REPLACE_REGEXPR('\D' IN 'this product 123 AVAR0001256701 manufactured in AVAR0001256725' WITH '_') From Dummy;
but this returning output like
Select Substr_REGEXPR('([0-9]+)' IN 'this product 123 AVAR0001256701 manufactured in AVAR0001256725' ) From Dummy;
This is returning me first occurrence of the number i.e. 123
I need to split them into rows.
Could anyone help me how to achieve this?
Thanks in advance!