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!
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Regex (or other option) for showing part of Hierarchical Class
We have a 2 to 3 level hierarchical class for our Items.
On Searches / Reports you can show the entire Hierarchical Class, or just the lowest level - but someone wants to see the 'middle' level
I assume there should be some kind of Regex or similar that could extract the middle text from between the two colons, but I'm no expert on regex. Also, I'm not entirely clear on the correct format for using Regex in Formula fields as the only example I can find is the substr suggestions in SuiteAnswers: LTRIM(regexp_substr({itemid},'[^:]*$'))
Also, I know some of our items only have two levels of Class, so there won't be 2 colons to search for (which may cause issues).
0