Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Delete every other line in notepad++

Tags:

csv

notepad++

Is there a way in Notepad++ to delete every other or nth line? I have a massive list of data and I need to reduce the size.

The data itself is not that important and out of a list of 10,000 items I only need a selection of 5,000

like image 817
fightstarr20 Avatar asked Jul 18 '13 22:07

fightstarr20


People also ask

How do I remove the space between lines in notepad?

The easy way would be select everything (Ctrl+A), go to Edit>Blank Operation>Trim Trailing Space. This should remove all the spaces in between.

How do I delete all text in Notepad?

Highlight the text in the Notepad box and press the Delete key on your keyboard. Type Ctrl + O, or right-click in the Notepad box. At the Save Notepad Changes prompt, click Yes.


1 Answers

I'm not sure Notepad++ is the best tool for this, but using the Power of Regex, we should be able to do it.

Open the replace menu, fill in ([^\n]*\n)[^\n]*\n in the "Find what" box and $1 in the "Replace with" box. Then select regular expression for the search mode, click replace all and every second line is deleted.

You can build similar regexes if you want to do something similar. For example, (([^\n]*\n){a})[^\n]*\n will replace every nth line if you replace a by n - 1 and [^\n]*\n([^\n]*\n) will let you keep even lines instead of odd ones.

like image 154
Jasper Avatar answered Nov 11 '22 21:11

Jasper