Spaces

Hi,

no answer yet, but I've made some progress. Is there a way to tell REGEXP_INSTR to ignore spaces in my string?

Sale I have this expression:

SELECT REGEXP_INSTR('"FO EM, FO LA","ABCDEF","12345"','"([[:alnum:]])+, ([[:alnum:]]+)"') FROM DUAL;

I can have any number of spaces in any part of the string. How can I tell Oracle to ignore the spaces when performing the check? Do I need to replace them? I need the spaces there, but ignore them during the pattern match. Received on Thu Jan 29 2009 - 08:45:38 CST