Hi
I have a requirement as follows. My Input file is as follows.
COL1,COL2,COL3,COL4,COL5
987,2,3~7~5,400~468~598,0005~4687~5980
1111,2,2~7,400~468,0005~897
Expected OUTPUT
COL1,COL2,COL3,COL4,COL5
987,2,3,400,0005
987,2,7,468,4687
987,2,5,598,5980
1111,2,2,400,0005
1111,2,7,468,897
COL3,COL4 and COL5 are in turn having own sub division with ~ as delimiter. COL3 can have any number of records till 80. If COL3 has 4 records then COL4 and COL5 contains same number of records.That is COL3 is dynamic.This can be done by counting and cutting columns in loop. But,How can this be done using some array structure to make it faster.