I have a paragraph and I need to extract a word from it.
Attention: Investigator: O'Toole, Tim Suspect Name: Ezekiel, David Account Number: 4323232
What I tried:
regexp_extract([Case_Desc],'Name : (.+)Account')
The above regex worked in tableau but for some reasons, toad for Oracle does not support this. Any help on this is really appreciated.
Thanks in advance.