Hi All,
I am trying to extract a portion of string using regular expressions in a unstructured text. We are able to do for a patterned text.
I have the following data in one of the fields. I tried for a uniform patterned values but it didnt work for undetermined pattern
Tried using regular expressions in multiple formats but no luck.
WITH INPUT AS
(
SELECT 'IN00012345 Vchr:A0000 012345 IHG:1-800-222-5555' FROM DUAL -- Need IN00012345
UNION
SELECT 'CE04441234,,,,' FROM DUAL -- Need CE04441234
UNION
SELECT 'TS00123234/6/1/2017' FROM DUAL --Need TS00123234
)
OUTPUT:
IN00012345
CE04441234
TS00123234
Any pointers on this ?
Thanks
KVB