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!
Saved Search: Display value after a specific word
Hi Gurus,
I am trying to write an formula in the Saved Search to extract the value after a words "REMARKS", but my result shows everything before the word "REMARKS" instead.
This is the formula used:
CASE WHEN INSTR({memo}, 'REMARKS') > 0 THEN SUBSTR({memo}, 0, INSTR({memo}, 'REMARKS')-1) ELSE '' END
My memo field has value such as:
*Non Inventory Item - Fixed Asset
REMARKS: Testing remarks
I wanted to only extract the value after the "REMARKS", thus it should show "Testing remarks".
Appreciate if anyone can provide some insight on this.
Thanks!