IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

To replace a string by another and convert to Fixed format


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
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
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
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 Developer


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

PostPosted: Tue Jul 29, 2008 1:29 am
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:

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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Replace each space in cobol string wi... COBOL Programming 2
No new posts Populate last day of the Month in MMD... SYNCSORT 2
No new posts PARSE Syntax for not fix length word ... JCL & VSAM 7
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Sortjoin and Search for a String and ... DFSORT/ICETOOL 1
Search our Forums:

Back to Top