Find and replace the "\n" string in Calc cells

[lduperval]

Hi,

I have a bunch of CSV files that contain the string “\n” in them. How to I replace that in Calc with a line feed? If the option is to edit the text file an import it afterwards, I can do that also. But I tried regexp finding “\n” and replacing it with “\n” but that doesn’t seem to work. the “\n” string remains in place.

Thanks,

L

P.S. The “” are not part of the string I’m trying to replace. Just the \n.

[Zizi64]

Use a secondary table with the formula:

=SUBSTITUTE(A1;"\n";CHAR(10))

Then - if you need it - you can use Copy-Paste Special (as TEXT) to eliminate the formulas and references.
Substitute.ods (12.4 KB)

[nobu]

Would the silly extension I created help?

\new Line

\new Line » Libreoffice Extensions

[lduperval]

Yes, this works great, thanks!

L