View Single Post
 
Old August 23rd, 2009, 11:35 PM
vickyso88 vickyso88 is offline
Registered User
 
Join Date: Aug 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hello!



Thank you for the responses.



To simplify the requirement, I made sample input txt files below and the sample output format in excel.



Input txt file #1



11 AAA

22 BBB

33 CCC



00 77 88 99

44 DDD GGG JJJ

55 EEE HHH KKK

66 FFF III LLL





Input txt file #2



11 MMM

22 NNN

33 OOO



00 77 88 99

44 PPP SSS VVV

55 QQQ TTT WWW

66 RRR UUU XXX



The output excel file format should look like this:



AAA BBB CCC DDD EEE FFF GGG HHH III JJJ KKK LLL

MMM NNN OOO PPP QQQ RRR SSS TTT UUU VVV WWW XXX



Assumptions:

- the input files are tab delimited

- same format for all input txt file

- 1 row per txt file in excel output



Please help.