Remove and replace all carriage returns in a string to blanks.

Insert this code in the input translation of a field to remove and replace the carriage returns.
Lotus Formula

@Trim(@ReplaceSubstring( insertfieldnamehere ; @NewLine ; " " ))

Posted by fbrefere001 on Thursday June 24, 2004