Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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.

like image 281
guazz Avatar asked Oct 14 '22 00:10

guazz


2 Answers

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.

like image 121
Patrick Cuff Avatar answered Oct 18 '22 13:10

Patrick Cuff


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.

like image 30
Marco Avatar answered Oct 18 '22 11:10

Marco