How to delete every 2nd line

R

RoseDawson

Newbie

Apr 22, 2012

28

3

• Jun 26, 2012

• #1

Hello,

You guys know a tool that can delete every 2nd line in a txt file or every 2nd row in a csv file ?

Thanks

 

ferma231

Elite Member

Jul 14, 2011

1,749

3,598

• Jun 26, 2012

• #2

Manualy

 

ExpressFans

Elite Member

Dec 11, 2011

1,751

639

• Jun 26, 2012

• #3

The second line is a "Enter" try the replace symbol with... or something like that option on MS word.If the content is not to "delicate" I'll give it a try if you don't find a solution.Since you're asking I'm assuming there are tens of thousands of lines which would be a big pain in the ass to do manually.

 

RightInTwo

Power Member

Feb 23, 2010

744

389

• Jun 26, 2012

• #4

Need to see an example of the lines. Is it HTML?

If it is HTML, you can download Notepad++ and do a find and replace. For example, if it has a line break <br/> you can do a find and replace for "<br/>" and have the replace field be empty.

 

kvmcable

Supreme Member

Dec 28, 2010

1,354

2,823

• Jun 26, 2012

• #5

Open in Excel, add ASAP utilities (free), go to Columns+Rows in ASAP and first option tell it to delete all even rows.

Done.

 

C

Chlorine

Newbie

Jun 26, 2012

4

0

• Jun 26, 2012

• #6

You would have to do it manually.

 

sk8tavou

Elite Member

Aug 28, 2011

1,797

1,435

• Jun 26, 2012

• #7

I can code a bot to do it i think its easy If you want pm me with a test csv to create it