Delete every other line in notepad++

csv notepad++
fightstarr20 picture fightstarr20 · Jul 19, 2013 · Viewed 53.2k times · Source

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

Answer

Jasper picture Jasper · Jul 19, 2013

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.

Related questions

Remove or replace LF from CSV file

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 …

Read More
How to remove unwanted columns and fields in Notepad++

I have a feed with the following columns: product_name,description,aw_product_id,store_price,merchant_image_url,merchant_deep_link,merchant_category,merchant_product_id Each line afterwards has all the information in this order. I only require …

Read More
How to concatenate text from multiple rows into a single text string in SQL server?

Consider a database table holding names, with three rows: Peter Paul Mary Is there an easy way to turn this into a single string of Peter, Paul, Mary?

Read More