entwined
08-14-2012, 09:52 PM
Hi troopers,
I have a text file that contains TAB delimited data. Here's a sample contents:
ID[tab]Description[tab]Code[tab]Count
INN.001.36[tab]Titles[tab]NL[tab]1
INN.001.37[tab]Titles[tab]NL[tab]1
INN.001.38[tab]Titles[tab]NL[tab]1
INN.001.39[tab]Titles[tab]NL[tab]3
INN.001.40[tab]Titles[tab]NL[tab]1
INN.001.41[tab]Titles[tab]NL[tab]1
INN.001.42[tab]Titles[tab]NL[tab]1
INN.001.43[tab]Titles[tab]NL[tab]1
INN.001.44[tab]Titles[tab]NL[tab]1
INN.001.45[tab]Titles[tab]NL[tab]1
*[tab] are TAB characters
Now I want the file itself to be converted to an excel file (.xls) so it will look like 4 columns A-D in excel sheet. It should appear in the sheet exactly like the above.
Any help would be very much appreciated. Thanks in advance... :)
I have a text file that contains TAB delimited data. Here's a sample contents:
ID[tab]Description[tab]Code[tab]Count
INN.001.36[tab]Titles[tab]NL[tab]1
INN.001.37[tab]Titles[tab]NL[tab]1
INN.001.38[tab]Titles[tab]NL[tab]1
INN.001.39[tab]Titles[tab]NL[tab]3
INN.001.40[tab]Titles[tab]NL[tab]1
INN.001.41[tab]Titles[tab]NL[tab]1
INN.001.42[tab]Titles[tab]NL[tab]1
INN.001.43[tab]Titles[tab]NL[tab]1
INN.001.44[tab]Titles[tab]NL[tab]1
INN.001.45[tab]Titles[tab]NL[tab]1
*[tab] are TAB characters
Now I want the file itself to be converted to an excel file (.xls) so it will look like 4 columns A-D in excel sheet. It should appear in the sheet exactly like the above.
Any help would be very much appreciated. Thanks in advance... :)