IBM Mainframe Forum

[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.

Select all

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:

Select all

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.

[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.