View previous topic :: View next topic
|
Author |
Message |
Benoy
New User
Joined: 25 Jul 2008 Posts: 10 Location: Chennai
|
|
|
|
My requirement is
I am having tab separated variable file(got by unloading the table).I need to convert
the file to fixed format and also have to replace <""> to <">.
The characters in the file will be in double quotes.
I am using ICEMAN to converts the file from VB to fixed,but
Didnt get solution for second requirement.
Eg
Code: |
200 "te""mple" "C""h ruch" |
Result should be
Code: |
200 "te"mple" "C"h ruch" |
|
|
Back to top |
|
|
Benoy
New User
Joined: 25 Jul 2008 Posts: 10 Location: Chennai
|
|
|
|
Hi all
I used file aid edit all option to replace """(2 dble quote) by "(1 dble).
It edits all
occurrences of data within the area specified by a start location and a length.
The syntax of the EDITALL parameter is:
EDITALL=(location,length,compare-data,new-data).
Ten used ICEMAN utility to convert the Varaiable file to fixed file.
Thanks
Benoy |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
DFSORT now has a find and replace function. You'll need z/OS DFSORT V1R5 PTF UK90013 (July, 2008) to use it. For complete details on FINDREP and all of the other new DFSORT functions, see:
Use [URL] BBCode for External Links
To change "" to " anywhere in your records, you can use:
Code: |
OPTION COPY
INREC FINDREP=(IN=C'""',OUT=C'"')
|
|
|
Back to top |
|
|
Benoy
New User
Joined: 25 Jul 2008 Posts: 10 Location: Chennai
|
|
|
|
Hi
The link u mentioned is very useful..
Thank U very much. |
|
Back to top |
|
|
|