Quick Text File Combine Trick
Yesterday, I went on a road trip and I gathered a pile of information using System Information for Windows (SIW) and saving it in a series of CSV files. SIW generated a 750 KB CSV file for each system with a load of information. Unfortunately, to perform a proper analysis in Excel, I needed all of the information in one file.
Now, I could have copied and pasted the text files all into one file but this would have been time consuming, especially if I had several hundred files. So, here is what I did to make life really easy for me. I simply copied all of the files into one directory by themselves and then ran the following command:
for %F in (*.csv) do type %F>>AllData.csv
This copied the contents of each file into one file called AllData.csv. That’s all it took! Now, I can open this up in Excel and then analyze away!
6 Responses to “Quick Text File Combine Trick”
-
Billy Girlardo Says:
August 14th, 2008 at 12:33 pmHaute Secure blocks that SIW site you’re broadcasting.
-
Dustin L. Says:
August 14th, 2008 at 1:09 pmYou can do the same thing with the copy command with less typing:
copy *.csv AllData.csv -
TA Says:
August 15th, 2008 at 1:57 pmSorry for posting this here, but your email address doesn’t seem to work.
I can’t seem to figure out how to navigate the FreeNAS tour. How do you get to the next article or step?
Thanks
-
Tim Fehlman Says:
August 15th, 2008 at 2:16 pmI’ll look at the FreeNAS tour and see what is wrong.
Tim
-
TA Says:
August 19th, 2008 at 2:13 pmSo what’s wrong?
-
Tim Fehlman Says:
August 19th, 2008 at 2:50 pmStill researching.
Tim
