Splitting record into multiple rows.

IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Splitting record into multiple rows.

Postby juzirulz » Sat Aug 22, 2015 2:27 am

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.
Posts: 1
Joined: Sat Aug 22, 2015 2:15 am
Has thanked: 1 time
Been thanked: 0 time

Re: Splitting record into multiple rows.

Postby NicC » Sat Aug 22, 2015 3:53 am

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.
The problem I have is that people can explain things quickly but I can only comprehend slowly.

These users thanked the author NicC for the post:
juzirulz (Sat Aug 22, 2015 7:23 am)
Global moderator
Posts: 3026
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times



  • Related topics
    Last post