CODEWITHSUNDEEP
batch-fileshellwindows-scripting
guazz
guazz

Reputation: 51

Command Line Script to Delete Header Row from a number of TXT files

What's the best method to delete the first line of text from a large (10k+) group of text files.

Upvotes: 5

Views: 6425

Answers (4)

ghostdog74
ghostdog74

Reputation: 342599

download sed for windows. Then do this

c:\test> sed -i.bak "1d" file

use a for loop to iterate files

Upvotes: 0

Marco
Marco

Reputation: 2907

If you can install TAIL in your sistem

tail -n +2 filename > finalfilename

shows all the filename except the first line.

The windows CMD, in my opinion, isn't the best "terminal". However, you don't need tail command. As Patrick Cuff said, you cand use the more command that does basically the same.

I think that is the best answer to do with buil-in commands.

If you know a bit about programming, you can make a small program that does what you want and call it in a bat file.

Also, you can use other windows terminals like cygwin, powershell or console that have more flexible built in commands to do this kind of stuff.

Upvotes: 1

Patrick Cuff
Patrick Cuff

Reputation: 29806

If PowerShell isn't an option, you can use the more command:

more [file] +2 > [new file]

Stick that in a for loop that also then renames [new file] to [file] and you'll have the file minus the first line.

Not pretty, but should work.

Upvotes: 3

Filburt
Filburt

Reputation: 18082

If using PowerShell is an option you could adopt from this post: Remove Top Line of Text File with Powershell

Upvotes: 0

Related Questions