Text parser to replace all new lines with space

[Baiwu_Zhang]

I’m trying to use the text parser to parse multiline texts into a single line. Can’t get it to work. I have tried: newline, newline+, /n in pattern, and space in New Value. None of it seems to work. The best I can get is to replace the first newline with space, but the following newline was not replaced.

Please help! Thanks!

[ManishMandot]

@Baiwu_Zhang here is the easiest solution

Use this formula;