REGEXP_SUBSTR
From: <mrdjmagnet_at_aol.com>
Date: Wed, 28 Jan 2009 09:03:54 -0800 (PST)
Message-ID: <282a7071-0aa4-440e-8737-70a70e048745_at_a39g2000prl.googlegroups.com>
Date: Wed, 28 Jan 2009 09:03:54 -0800 (PST)
Message-ID: <282a7071-0aa4-440e-8737-70a70e048745_at_a39g2000prl.googlegroups.com>
I'm working on this now but figured I'd cheat at the same time and see if someone else can help.
I have a text pattern: "M, MO" or "M,MO" or "HELO","M,MO"
I am looking to extract the "M,MO" pattern. First I remove the space after the comma:
v_fld := REPLACE(v_fld,', ',',');
But now I'm having trouble getting the pattern out. Here are some attempts:
SELECT REGEXP_SUBSTR('"M, MO"','"*,*"') FROM dual; SELECT REGEXP_SUBSTR('"M, MO"','"([[:alnum:]],[[:alnum:]])"') FROM dual;
No luck yet. Received on Wed Jan 28 2009 - 11:03:54 CST