11-06-2012
5,
0
Join Date: Oct 2009
Last Activity: 4 December 2017, 6:16 PM EST
Posts: 5
Thanks Given: 0
Thanked 0 Times in 0 Posts
Here is some sample data of the files:
The source file is having data like:
<file1.csv>
field1,field2,field3,field4,field5,field6,field7,field8,field9,field10,field11,field12
sample data:
1,ABC001,Tropical Rainforest,Americas,Sacramento,Mr David Cemes,123,Subway,456,McDonalds,977,KFC
Depending on my requirement,
New file1 should have:
field1,field2,field3,field4,field5,field6,field7,field8
sample data being:
1,ABC001,Tropical Rainforest,Americas,Sacramento,Mr David Cemes,file1_0001
and file2 should have:
field1,field2,field3
sample data being:
file1_0001,123,Subway
file1_0002,456,McDonalds
file1_003,977,KFC