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!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
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?