Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Finding a particular substring in the middle of a string
Hi
For a workflow, in the formula, I have the following:
REGEXP_SUBSTR({title},'[S][0-9]+')
This works when the particular string pattern is at the start of the {title} field.
However, it does not work if that string pattern is in the middle of a text string.
For example:
FW: Invoice 124678,S123548
If this string combination is in the middle of another field, such as {incomingmessage}, this works to extract the text even when it is surrounded by blank spaces, other strings, punctuation,etc
Why would there be a difference in how the expression works if it is in the {title} field vs {incomingmessage} field?
Tagged:
0