Page 1 of 1

How to copy comma seperated colums in to rows?

PostPosted: Mon Jan 28, 2013 4:59 pm
by senthil_baasha
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.

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

PostPosted: Mon Jan 28, 2013 5:40 pm
by BillyBoyo
You've asked this already elsewhere. Topic locked.