For a RegEx_Substr, how do I extract words with a space or no space? For example the words I’m trying to get out of the string: New Record and OrderRecord
I’m lost and not sure what to do. I tried REGEXP_SUBSTR(LogText,'([^ ]+)’,1,1), but that’s only working for OrderRecord.
New contributor
HoosierDuckling is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.