Extracting string from an email message in case capture and storing as a variable
I have the following scenario. There are email messages sent to a support email message which are being converted into cases via the capture functionality in Netsuite.
I have a workflow that looks through the incoming message field and finds key words to categorise the case issue (i.e. using the ‘set field value’ as a workflow action)
This is working fine.
There is a requirement also to search the incoming message for a text string which would be the sales order number. The sales order number is in the format of SO254548.
The extracted sales order number from the body of the email message needs to be stored in a field.
According to NS support, this is possible using a script.
I am very new to writing script (I have written only two basic ones till date).
What kind of script would I need?
Would this be a workflow action script?
For the actual search of the text string, I have been looking into using REGEXP to extract any alphanumeric string that begins with SO.
However I don’t think I am using Regexp correctly in a suitescript.
For example, for another script, I have tried to combine REGEXP with split() on a JSON Stringified search result.
I end up getting something like the following
This was the lines in the script that produced this
I am not sure where to begin at the moment so would appreciate suggestions on what I should look into to get the result I want.