10-10-2006
41,
0
Join Date: Feb 2006
Last Activity: 4 December 2009, 2:24 AM EST
Posts: 41
Thanks Given: 0
Thanked 0 Times in 0 Posts
Modifying the final output file
Hey all,
I am haivng n number of files all of them are of the same format but different details. i.e
File1 is having the folloeing details:
"Account1",123
"Account2",10
"Account3",12355
"Accountn",555
File2 is having the folloeing details:
"Account1",1234
"Account2",100
"Account3",2290
"Accountn",679
and so on.....so as you can see i am having n number of files, all files have the same account number inside and the only difference is in the number of recrods each account has in each file.....Now what i want to do is to generate a final file which will have all the accounts mentioned earlier along with their records, it will be somehow i a table format.i.e.:
Final output file should look like the following:
"Account1",123,1234
"Account2",10,100
"Account3",12355,2290
"Accountn",555,679
Any idea on how to do this?