|
|
| Author |
Message |
Benoy
New User
Joined: 25 Jul 2008 Posts: 9 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 |
|
 |
References
|
|
 |
Moved: Fri Jul 25, 2008 6:15 pm by superk From JCL to DFSORT/ICETOOL |
Benoy
New User
Joined: 25 Jul 2008 Posts: 9 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 Moderator
Joined: 15 Feb 2005 Posts: 4687 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:
www.ibm.com/systems/support/storage/software/sort/mvs/ugpf/
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: 9 Location: Chennai
|
|
|
|
Hi
The link u mentioned is very useful..
Thank U very much. |
|
| Back to top |
|
 |
|
|