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!
Formula to Extract String from Text Set
Simply speaking, here is an example.
This is the text:
"Form name: Emails Submitted: Jan. 5, 2021, 9:42 p.m. Name: Moussa Surname: Farhat Company: Medifarhat Position: G.M Country: Syria Email: mossafarhat67@gmail.com Phone: 00963933533591 Message: This order for Malaysia NBR latex"
From this, we need to extract only the Company. So that means I need the text between "Company:" and "Position:".
I've tried a few SUBSTR formulas without much luck. Any thoughts if this is possible in saved searches?
Thanks,
Hunter