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!
Formula for Removing Carriage Returns
Is there a formula to remove carriage returns from fields in a Saved Search? I have a custom Text Area field that is being used by a 3PL integration and have discovered that if the user hits enter within that Text Area field, the 3PL's system sees that as a new line when it shouldn't. I'm hoping to "scrub" the carriage returns out via formula before the data is sent to the 3PL.
I tried the REPLACE function with <br>, '<br>', /n and '/n' based on some info I found on SuiteAnswers. No luck. Thanks!