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!
Regular Expression in Search Formula
Hi,
For the life of me, I can't find a way to replace multiple characters in a search formula.
Basically, I'm trying to escape out all the "&" and "=" symbols from a string stored in a custom field ( {custentity_download_id} ).
I believe I should use the REPLACE or maybe the REGEXP_REPLACE commands, but I can only get it to work on a single character and I need to swap out both (e.g. "&" into %26; "=" into %3D ).
I've tried so many different things, I'm now thoroughly confused.
Has anyone done this before? If so, any guidance would be appreciated.
Thanks,