Page 1 of 1

split each records in a file with out writing cobol program

Posted: Tue Sep 13, 2011 8:41 am
by ickgeek23
Hi to all,

I have one input file like

name1----------------------course1,course2,course3
name2----------------------course2,course3
name3----------------------

output file should be like
name1----------------------course1
name1----------------------course2
name1----------------------course3
name2----------------------course2
name2----------------------course3
name3----------------------

In this course name is of variable length (its length is not fixed), i need to solve with out writing any cobol program, i have to use some utility ..... Can anybody help me on this....


Thanks in advance

Posted: Tue Sep 13, 2011 10:27 am
by DikDude
Which sort product is used on your system?

Posted: Tue Sep 13, 2011 11:16 am
by ickgeek23
we are using Syncsort

Posted: Thu Sep 15, 2011 3:52 pm
by ickgeek23
Can anyone help me on this pls ......

Posted: Thu Sep 15, 2011 5:08 pm
by MrSpock
I don't think that the technical representitives from Syncsort have a presence on this forum. You'd probably get better results if you opened a support ticket with them directly.

Posted: Thu Sep 15, 2011 9:16 pm
by DikDude
Thes can probably be done using PARSE with Syncsort.

Posted: Fri Sep 16, 2011 12:44 am
by ickgeek23
Can you please help me how to do this with parse