Possible to remove new lines from a field?

[#1]

I have a field called Comments and the values in the field (strings) sometimes include new lines.  The issue is when I represent this field on a straight table, even with the cell wrap upped to 4 lines, some of the string is getting cut off.  I am wondering if it's possible to remove new lines all together from the values in the field? 

[jerem1234 · Accepted solution]

Try:

replace(FIELD, chr(10), ' ')

This will replace the new lines with a space.

Hope this helps!

[jerem1234]

If you want to completely remove it, use:

purgechar(FIELD, chr(10))

[#4]

Hi,

check the applicaton. Test data is as below.

ID	Comments
1	1 First String 1 Second String 1 Third String
2	2 First String 2 Second String
3	3 Frist String
4	4 Frist String
5	5 Frist String 5 Second String 5 Third String 5 Fourth String 5 Fifth String

[yakir_manor]

see the following links:

1. Newline - Wikipedia

2. Whitespace - Wikipedia

for me i needed to remove newline and whitespace so i use:

let vNewString = replace(replace(replace(vString, chr(13), ''), chr(10), ''), ' ', '');

enjoy!