# Splitting the message based on the batch number

Splitting the message based on the data number

Hi Experts,

Could you please suggest the feasible solution for splitting the message based on the data number for the following file?

I have 4 fields in my input flat file, contains multiple records. Requirement is to split the file and create separate output file which has the same data numbers.

Input: single file

Field1 2 3 4

001 x y z

001 y z x

001 z x y

002 x y z

002 y z x

003 x y z

003 y z x

003 z x y

Output: multiple files

File1:

001 x y z

001 y z x

001 z x y

File2:

002 x y z

002 y z x

File3:

003 x y z

003 y z x

003 z x y

Really appreciate your valuable inputs..

Thanks

Kumar