Txt files to Excel report
Posted on 2003-12-01
I have three txt files, say file1, file2 and file3.
File1 has format like:
Name 4 Data4
File2 also has the same format, just that sometimes Names could be more or less than file1
(here Name2 is missing, but Name5 is added)
File3 also has the same format, just that sometimes it can have Names that are more or less than file1 and file2.
(Name3, Name4, Name5 missing and Name6 added).
I want to capture all the Names present in all the three files and format it into one output file with,
Name, Data, Text, Variable columns and show these as 4 columns in an excel spreadsheet.
My output in excel will look like:
Name1 Data1 text1 variable1
Name2 Data2 - variable2
Name3 Data3 text3 -
Name4 Data4 text4 -
Name5 - text5 -
Name6 - - variable6