Printable View
I am trying to read in a large file and process information based on groups of data. For example:
1111,name1,2,222
1111,name1,3,222
1111,name1,7,111
1200,name2,1,111
1203,name3,4,222
1203,name3,7,333
I would like to process all the 1111s,1200 and 1203s and append the results to an out put file. I have tried if statements and Do loops with out too much luck. Any suggestions would be appreciated. Thanks...
If your data is comma delimited then parse the data and place it an access Database. From there you can sort and output to just about any format.
Thanks for the suggestion. I still am wondering if it could be done with Do/Loop/IF statements.
How about creating an array, parse the data and add it to the array then sort it.
I'm affaid that the array would be too large. I have about 30,000 entries with an average of about 5 sublistings. Each sublisting has 12 "fields".