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!
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!
Tagged:
0