[rsm_ryan_meyer Contributions: 0Level 1☆]

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!
This is a cached copy. Click here to see the original post.

[ERPExperts Contributions: 0Level 1☆]

Just to check, have you tried n as that's the correct way around?

[rsm_ryan_meyer Contributions: 0Level 1☆]

Thanks for the reply.

I figured out what works for carriage return (chr(13) is apparently the code representation of CR); this formula is apparently finding the CRs:

REPLACE({custbody_field},chr(13),'')

However, when I export to Excel, they are still there. I know the formula is finding them as I modified it to REPLACE({custbody_field},chr(13),'aaa') at one point and the 'aaa' was showing up in the correct places in the results. I tried REPLACE({custbody_field},chr(13),' ') , REPLACE({custbody_field},chr(13),'') , REPLACE({custbody_field},chr(13),null) and REPLACE({custbody_field},chr(13)).

Results of all those test still send CRs to Excel. It's like the NS results are overriding the formula. Any other thoughts?

[dominicb Contributions: 0Level 1☆]

Have you tried replacing chr(13) and chr(10) in case its an LF rather than a CR?

[rsm_ryan_meyer Contributions: 0Level 1☆]

Thanks for the reply. I did end up using that and replace(replace(Name,CHR(10),''),CHR(13),'') ended up working for me.

[Author]

Posts