Skip to Content
0
Feb 18, 2008 at 06:55 AM

grouping records based on identifier into seperate files

8 Views

Hi,

I have a file to file(s) scenario, where in the source file I will get a collection of records with identifier in the first place of a record, now I need to group the records in to seperate files based on the identifier.

Ex:SFile

identifier1,field1,field2

identifier2,field1,field2,field3,field4

identifier2,field1,field2,field3,field4

identifier1,field1,field2

identifier3,field1,field2,field3,field4,field5

identifier2,field1,field2,field3,field4

identifier1,field1,field2

identifier1,field1,field2

identifier3,field1,field2,field3,field4,field5

identifier4,field1,field2,field3,field4,field5,field6

..... and so on.

required:-

TFile1 with idetifier1 records

TFile2 with idetifier2 records

TFile3 with idetifier3 records

TFile4 with idetifier4 records

Can any one helpme how to handle this scenario.