Remove or replace LF from CSV file

Question

I have some huge CSV files where sometimes the lines end with LF instead of CRLF, for example:

pippo LF
pluto CRLF

I want to convert these two lines into a single line, like pippo pluto CRLF.

I'm trying to do this in Notepad++ (Windows 7), but I'm not able to do it...

So you don't want to replace all occurrences of `LF` with `CRLF`? – Instead, do you want to _remove_ all occurrences of `LF`? (If I misunderstood you, my edit is wrong.) — Henke, Sep 09 '22 at 14:15

score 10 · Answer 1 · edited Sep 09 '22 at 14:31

10

To do so:

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

edited Sep 09 '22 at 14:31

Henke

4,445
3
31
44

answered Dec 03 '14 at 12:43

Martin

101
1
3

score 4 · Answer 2 · edited Sep 28 '13 at 07:52

4

In "Edit" menu, choose "Convert line feed" and "Convert to windows format (CRLF).

NB: I'm not quite sure of the labels because I have not an english version of Notepad++.

Notepad++ menus evolve from version to version. In the English version of Notepad++ 6.3.2 from the Edit menu, select EOL Conversions => Windows Format.

edited Sep 28 '13 at 07:52

AdrianHHH

13,492
16
50
87

answered Sep 19 '13 at 07:48

Toto

89,455
62
89
125

score 1 · Answer 3 · answered Sep 19 '13 at 07:40

1

Just replace all the \r with "".

To do so:

Ctrl+F
Go to "Reaplace" tab
In "Find What" paste: \r
In "Replace with" paste: ""
Choose "Extended" in "Search Mode"
Replace All

answered Sep 19 '13 at 07:40

Eugene S

6,709
8
57
91

2

Hi, I solved using a trick: Replace \n with null, and after that replace \r with \r\n. Thanks – Antonio Oct 04 '13 at 09:16

Remove or replace LF from CSV file

3 Answers3