View previous topic :: View next topic
|
Author |
Message |
nimisanand
New User
Joined: 22 Nov 2005 Posts: 24
|
|
|
|
Hi,
I have a file which has some account related data which is a table extract and contains a var char field.
Input
12345678 abdcdelelele:57D://dsfdsf..cderfe.dwerggd:59://sdfsdfdsfdsf
45464355 madfdfdsfdfdfdsfdf:57D://w3fdsfdsfdf..dsfdfdf:59://dsfdefdsf
I would like to extract the data present between :57D:// and :59://. The position of these are not constant in the file.
Output required
12345678 dsfdsf..cderfe.dwerggd
45464355 w3fdsfdsfdf..dsfdfdf |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
nimisanand,
I think this can be done using the PARSE parameter if you have SyncSort for z/OS R 1.3 or later. If you dont have the recent version of SyncSort, a REXX solution could be an alternate approach. Search the forum and you'll find some tested/working code. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
If the file to be processed has many records, rexx is not a good performance choice.
What you want to do is rather simple in cobol as well. . . |
|
Back to top |
|
|
|