Page 1 of 1

Splitting record into multiple rows.

PostPosted: Sat Aug 22, 2015 2:27 am
by juzirulz
Hello - I have an input file with the following format:

First column (one or more member Ids) are from 1 to 100 bytes.
Second column (effective date) is from 101 to 110 bytes.

1-------------------100  101------110
16925178                 2014-01-10
"6260947, 7996116"       2015-12-31
2268370                  2014-07-01
"384121, 5597844"        2010-08-23


My output needs to look like this:
16925178                 2014-01-10
6260947                  2015-12-31
7996116                  2015-12-31
2268370                  2014-07-01
384121                   2010-08-23
5597844                  2010-08-23


Any suggestions on how to achieve this using Sort or Icetool? Thanks in advance.

Re: Splitting record into multiple rows.

PostPosted: Sat Aug 22, 2015 3:53 am
by NicC
Please use the ciode tags when posting JCL, control cards, data, code and anything else that requires a fixed font. Don't know what code tags are? Then search the forum - there are plenty of references and if you use the POSTREPLY button you shoulod be able to figure it out for yourself. I will code your first post for you.