Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
To replace a string by another and convert to Fixed format

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
Author Message
Benoy

New User


Joined: 25 Jul 2008
Posts: 9
Location: Chennai

PostPosted: Fri Jul 25, 2008 3:40 pm    Post subject: To replace a string by another and convert to Fixed format
Reply with quote

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
View user's profile Send private message
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

PostPosted: Mon Jul 28, 2008 6:22 pm    Post subject: To replace a string by another and convert to fixed format
Reply with quote

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
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 4687
Location: San Jose, CA

PostPosted: Tue Jul 29, 2008 1:29 am    Post subject:
Reply with quote

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
View user's profile Send private message
Benoy

New User


Joined: 25 Jul 2008
Posts: 9
Location: Chennai

PostPosted: Tue Jul 29, 2008 9:27 am    Post subject:
Reply with quote

Hi
The link u mentioned is very useful..

Thank U very much.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1