Syncsort - split records into different files by groups
Posted: Sat Mar 28, 2009 11:46 am
Hi is it possible to copy the data until the condition matched. My requirment is that I need to split the data into three different files based on header or trailer condition.File always have 3 header and 3 trailer.
e.g
input file
HEADER 1234
ram
shyam
TRAILER02
HEADER 1234
tom
jack
TRAILER02
HEADER 1234
rohit
bodhi
TRAILER02
output files
file 1
HEADER 1234
ram
shyam
TRAILER02
file 2
HEADER 1234
tom
jack
TRAILER02
file 3
HEADER 1234
rohit
bodhi
TRAILER02
It is possible to do so in sort? Please let me know if you need more clarification.
Thanks
Bodhi
e.g
input file
HEADER 1234
ram
shyam
TRAILER02
HEADER 1234
tom
jack
TRAILER02
HEADER 1234
rohit
bodhi
TRAILER02
output files
file 1
HEADER 1234
ram
shyam
TRAILER02
file 2
HEADER 1234
tom
jack
TRAILER02
file 3
HEADER 1234
rohit
bodhi
TRAILER02
It is possible to do so in sort? Please let me know if you need more clarification.
Thanks
Bodhi