How to copy comma seperated colums in to rows?



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

How to copy comma seperated colums in to rows?

Postby senthil_baasha » Mon Jan 28, 2013 4:59 pm

My header records holds abcde@tst.com,efgh@tst.com,ijklmnop@tst.com. I need to extract this email Id RECORDS from header record only and write it in output file in to rows in output PS file. The logical record length is 80 and FB. But the length of email Id will vary everytime in input file.May be we can collect as every email id ends by comma. so can some one help.

Output file expected ; -
abcde@tst.com
efgh@tst.com
ijklmnop@tst.com

Note: - The length of email id records which are seperated by commas are unknown so not able to decide by coulmn size to write in output file.
Can some one post a SORT/ICETOOL JCL to help me in this.
senthil_baasha
 
Posts: 1
Joined: Mon Jan 28, 2013 4:51 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to copy comma seperated colums in to rows?

Postby BillyBoyo » Mon Jan 28, 2013 5:40 pm

You've asked this already elsewhere. Topic locked.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post