Change format to file II
hi all...
i have a big problem, and i hope someone can help me...
i have a flat file, and its columns are separated by comma (CSV), something like this:
78 , 204R180 , 90/100 , 200001 , 12 ,200002 ,13 .....
78 , 204R180 , 90/100 , 200001 , 29 ,200002 ,30 .....
78 , 204R180 , 90/100 , 200001 , 807044 ,200002 ,742114 .....
78 , 204R181 , 70/90 , 200001 , 27 ,200002 ,88 .....
78 , 204R181 , 70/90 , 200001 , 61 ,200002 ,99 .....
78 , 204R181 , 70/90 , 200001 , 1824515, 200002 ,2060349 .....
and i need the next:
78 , 204R180 , 90/100 , 200001 , 12 , 29 , 807044
78 , 204R180 , 90/100 , 200002 , 13 , 30 , 742114
78 , 204R181 , 70/90 , 200001 , 27 , 61 , 1824515
78 , 204R181 , 70/90 , 200002 , 88 , 99 , 2060349
i get group by the first 3 field (78, 204R180, 90/100 AND 78,204R181,70/90), and for each group i read the field corresponding to the year-month (200001- 200002), and i read the 3 values, what are in 3 diferents lines, but with the same key.
is that possible? please, help me, i don't know what to do... any idea, thanks