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.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
NSC | Saved Search Formula to get a String in the Value of a Field
Scenario
User has the following value in entityid field: abcde fghijk(53qw4ertyuiop12345a67s89)
They need to pull just the 53qw4ertyuiop12345a67s89 from that string/pattern.
Solution
Use either of these in a Formula (Text) field in the search Results:
- REPLACE(REGEXP_SUBSTR({entityid},'[^(]+$'),')','')
- Using this will pull the string between the parenthesis.
- SUBSTR({entityid}, INSTR({entityid}, '(') + 1, 24)
- Using this will pull the first 24 characters after the opening parenthesis. Use this if you need to get only a specific number of characters after the ( symbol.
-----
If you find this information useful, let us know by reacting or commenting on this post!
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!
Tagged:
0