Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Keyboard Ninja: Concatenate Multiple Text Files in Windows

You have a directory full of Log Files that you want to import into Excel or a database so you can do some processing on them… but there are hundreds of files… how do you make them into a single file?

Answer: Pull out your DOS hat, open a command prompt, and then use the “for” command.

The syntax works something like this:

for variablename> in (directorylisting>) do command> variablename>

So if you wanted to append all of the *.log files in a directory, you’d use the “type” command and then pipe it into a single file using the >> operator.

The difference between >> and > is that the former appends data to the end of the file, and the latter will completely replace the file, which would be pointless for what we want to do.

So here’s the command you’d run, assuming you are in the directory containing the log files.

for %f in (*.log) do type "%f" >> aggregate.txt

And yes, I actually just used this command for a project at work, which is why I’m writing up this article. =)

Random thought: What on earth would a DOS hat look like?

The post Keyboard Ninja: Concatenate Multiple Text Files in Windows appeared first on IMHABIB - Dr.Virus's Technology Blog.



This post first appeared on Dr.Virus Technology, please read the originial post: here

Share the post

Keyboard Ninja: Concatenate Multiple Text Files in Windows

×

Subscribe to Dr.virus Technology

Get updates delivered right to your inbox!

Thank you for your subscription

×