Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Regexp Substring in Workflow
Hi
I have the following patterns of strings that I am trying to extract using a regexp_substring formula in a workflow:
"Our purchase order no is 2152456"
"PO 2154548"
"Our PO is 124548"
The text string will always be "our purchase order; PO or our po"
This sentence will be in the middle of a body of text.
I am trying to extract the numbers after the text pattern up till the first blank space or full stop.
i.e. I am trying to extract 2152456 for the first example, 2154548 in the second example and 124548 in the third example.
The Regexp_substring formula I am using is: