Help - File Input

[Ronnie]

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...

[EHE]

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.

[Ronnie]

Thanks for the suggestion. I still am wondering if it could be done with Do/Loop/IF statements.

[EHE]

How about creating an array, parse the data and add it to the array then sort it.

[Ronnie]

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".