HOW TO: Remove newline characters using an expression

Version 1

    To remove newline characters use the REPLACESTR function. Newline characters require the CHR function and the ASCII value of the character in the data.
    The ASCII value for line feed is 10 and the value for carriage return is 13.

    Example

    Use the following expression to remove a line feed in a string:

    REPLACESTR(1,STRING_PORT,chr(10),'')

    To remove a line feed and carriage return in a string use the following expression:

    REPLACESTR (1,STRING_PORT,CHR(10),CHR(13), '')