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!
Where is a list of Wildcards and Operators
Hi all,
I spent half the night trying to find an understandable list of wildcards and operators for NetSuite SQL and am stumped. I'm trying to remove everything to the right of a colon : including the colon in a formula (text) search result.
ie., search result is "055 Vendor Name : Vendor Contact"
I've used various trim functions with no success and think I'm just running into my own dumbness... I started out with...
ltrim({cuscolname}, ' [:*]')
And have tried what seems like 100's of variations of the above with no success yet. Grrrr. Does anyone feel like taking pity on me and helping out?