Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ 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
View previous topic :: :: View next topic  
Author Message
Benoy

New User


Joined: 25 Jul 2008
Posts: 10
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

Benoy

New User


Joined: 25 Jul 2008
Posts: 10
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: 7130
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: 10
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
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Converting Variable block file to Fix... bhavana yalavarthi DFSORT/ICETOOL 10 Tue May 16, 2017 2:20 pm
No new posts Fileaid Update Replace with null string descann Compuware & Other Tools 4 Mon May 15, 2017 3:00 pm
No new posts Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm
No new posts Format record to remove Leading zeroes Learncoholic DFSORT/ICETOOL 14 Wed Apr 05, 2017 2:43 pm
No new posts How to pick only YYMMDD from DATE1P (... atulbaviskar SYNCSORT 7 Wed Mar 22, 2017 11:39 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us