Start a new topic
Answered

How to make a query with regular expressions ?

Hello,


My query with regular expressions is modified in xDI Process.


Here is my original Oracle query :


table(cast(multiset(select level from dual connect by  level <= length (regexp_replace(REPLACE(HIRE_NOTES_2.Hire_Notes,CHR(13)||CHR(10),'|'), '[^|]+'))  + 1) as sys.OdciNumberList))


Here is the query in xDI process :


(table(cast(multiset(select level from dual connect by level <= length (regexp_replace(REPLACE(HIRE_NOTES_2.Hire_Notes,CHR(13)||CHR(10),'|'), '[^||[^|+'))  + 1) as sys.OdciNumberList))



Best Answer

To fix this issue we should use double bracket in regular expression:



1 Comment

Answer

To fix this issue we should use double bracket in regular expression:



Login to post a comment