Removing Line breaks on Strings

[NiceDuck 19]

How do we remove the line break on string?

I need to convert something from this:

text1

text2

 

to this:

text1text2
 

[NiceDuck 19]

this is just another trivia, as for this case, we can use this formula:

REPLACE([@field:fieldname],CHAR(10),'')

I hope it heps anyone.

[lengleng 1]

For anyone that might be confused with Char(10), I'd like to add that 'Char(10)' is a character represented by ASCII Code 10, which is a Line Feed, it's basically a new line.

More info:https://stackoverflow.com/a/7647983