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!
Format Item Name/Number as Numeric with no Comma
Here's an interesting one - I'm trying to convert our Item Name/Number to a number field in this search (as we use incremented numbers here) for the purpose of sorting newest items in a item list view (we're importing almost 10000 skus and the internal ID's didn't auto-increment with our order of skus).
If I do Formula Numeric and TO_NUMBER though, it adds a comma. I tried several combinations of TO_NUMBER and TRIM, REGEX REPLACE but can't seem to get it quite right.
any thoughts on a workaround?