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!
NSC | TRIM Saved Search
Scenario: Users may need to create an Item saved search that returns a part of a character string but TRIM TRAILING function do not work.
Solution: For example Inventory Items' External IDs are displayed like so "Shirt - Small - AB1" and the user would like to return only the text after the last dash " - " which in this case would be "AB1".
Users can use the below formula:
Formula (Text) | SUBSTR ({externalid},INSTR({externalid},'-',-1,1)+1)
You can play with this formula but the example must give you enough idea on how you would edit it to get the result that you need.
Niks Blando-Oracle | Ask A Guru?️
Learn how to Refer A Member|Earn the Answer Accepter Badge|Be the Content Creator of the Quarter|Vote for the content you want to see!
Expand your NetSuite knowledge by joining this month'sAsk A Guru Live about Advanced Accounting.RSVPon this event now!