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 How to pick only YYMMDD from DATE1P (... atulbaviskar SYNCSORT 7 Wed Mar 22, 2017 11:39 am
No new posts Date and time format in CICS Chandru3183 CICS 2 Sat Mar 18, 2017 12:46 pm
No new posts Replacing same string with different ... vickey_dw DFSORT/ICETOOL 6 Wed Feb 22, 2017 10:44 pm
No new posts Convert current to hex value gopurs DFSORT/ICETOOL 4 Wed Feb 15, 2017 5:40 am
No new posts Count Trailing Spaces in variable str... Virendra Shambharkar SYNCSORT 10 Thu Feb 02, 2017 12:23 pm


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