Single Flat File needs to slipt in to N files depending up on matched rows

46 Views

Hi All,

I have a requirement like...my incoming file(single file) needs to be split into N files based on a number of rows matches to each other. (Rows are matched up on 5 fields)

my incoming file is like this .....

A,name,name2,name3,name4,name5,name6,name7,.....,.....,........,.....,.....

B,name,name2,name3,name4,name5,name6,name7,.....,.....,........,.....,.....

B,name8,name2,name3,name4,name5,name6,name7,.....,.....,........,.....,.....

I need to split this file and my ouput file should be like this

One File:

A,name,name2,name3,name4,name5,name6,name7,.....,.....,........,.....,.....

Second File:

B,name,name2,name3,name4,name5,name6,name7,.....,.....,........,.....,.....

Thrid File:

B,name8,name2,name3,name4,name5,name6,name7,.....,.....,........,.....,.....

Can anyone tell me how this can be achieved?

Thanks,

Rajeev.