Remove or replace LF from CSV file

Antonio picture Antonio · Sep 19, 2013 · Viewed 29.9k times · Source

I have some huge csv files where sometimes the lines end with LF instead to CRLF, ie:

pippo LF
pluto CRLF

I would have a line like pippo pluto CRLF

I'm trying to use notepad++ under Windows 7 but I'm not able to do that...

Answer

Martin picture Martin · Dec 3, 2014

To do so:

Ctrl+F
Go to "Reaplace" tab
In "Find What" paste: ([^\r])\n
In "Replace with" paste: \1
Choose "Regular expression" in "Search Mode"
Replace All