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.
juzirulz
 
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.
Regards
Nic

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


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post