Replace Statement

[Former Member]

Hello,

I would like to replace [CRLF] in the text with space. I tried:

=REPLACE(@shipmentText,"[CRLF]"," ") 

but that just replaces CRLF instead of [CRLF] (with squarebrackets).

Any ideas,....

Best regards,

Dharmi

[Former Member · Accepted solution]

Hi Dharmi,

The string to replace is being treanstlated to RegularExpression.

Try the following:

=REPLACE(@shipmentText,"\[CRLF\]"," ")

Regards,

Udi

[Former Member · Accepted solution]

Thanks Udi.

[Former Member · Accepted solution]

Hi Udi,

Do you know how to put an enter instead of the space?

Hoping for prompt reply again.

Best regards,

Dharmi

[Former Member · Accepted solution]

Hi Dharmi,

Try this...

=REPLACE(@shipmentText,"[CRLF]",CHR(10))

Regards,

Udi