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

Double quotes from one perticular column to another column


IBM Mainframe Forums -> CLIST & REXX
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
shinderajan222
Warnings : 1

New User


Joined: 28 Aug 2008
Posts: 12
Location: PUNE

PostPosted: Wed Nov 12, 2008 3:26 pm
Reply with quote

I need to supress double quotes from one perticular column to another column ....Does antbody know any command?
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed Nov 12, 2008 8:55 pm
Reply with quote

Hello,

When you have a question, you need to start a new topic for your question rather than posting a reply to some long inactive, unrelated topic.

If you explain what you want to do more clearly, someome may have a suggestion.

It will probably help if you post examples of what you "have" (the input) and what you want it changed to (the output).
Back to top
View user's profile Send private message
shinderajan222
Warnings : 1

New User


Joined: 28 Aug 2008
Posts: 12
Location: PUNE

PostPosted: Thu Nov 13, 2008 10:07 am
Reply with quote

Hi,

Sure next time onwards I will take care of this.

Actaully I need to supress double quotes in a PS file in perticular column.


Suppose as an example,

" I am doing my Job at "Pune" from last one year"

this is the text in the file and I have to supress double quotes of Pune

Please have a note that I want to supress double quotes only in single column.

Kindly let me know if this is NOT clear yet....
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Nov 13, 2008 10:43 am
Reply with quote

Hello,

Quote:
Kindly let me know if this is NOT clear yet....
Not quite yet. . . i'm slow tonight icon_confused.gif

Quote:
I want to supress double quotes only in single column
For this topic, what is a "single column".

The sample data has 4 double-quotes. The 2 on either side of Pune are to be removed. What is the rule for supressing those quotes? If the data was
" Pune and Channai have "ttc" and so does B'lore"
or
" "Pune" and "Channai" are looking for "new freshers"
what should be suppressed and what are the rules for suppression.
Back to top
View user's profile Send private message
agkshirsagar

Active Member


Joined: 27 Feb 2007
Posts: 691
Location: Earth

PostPosted: Thu Nov 13, 2008 12:00 pm
Reply with quote

You can show us a sample output for the input given in your question. That way it will be easier for us to offer suggestions .
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Thu Nov 13, 2008 9:06 pm
Reply with quote

... and please use BBCode so we can tell the difference between
Code:
" (a double quote)
and
Code:
'' (2 successive single quotes)
Back to top
View user's profile Send private message
Pedro

Global Moderator


Joined: 01 Sep 2006
Posts: 2547
Location: Silicon Valley

PostPosted: Thu Nov 13, 2008 10:41 pm
Reply with quote

Assuming it is a range of columns, and you can figure out what those columns are. And you did not say what environment you are in...

For example, if column range is 13 through 27

In editor:
Code:

C '"'  ' ' All  13 27
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 -> CLIST & REXX

 


Similar Topics
Topic Forum Replies
No new posts Replacing 'YYMMDD' with date, varying... SYNCSORT 3
No new posts How to load to DB2 with column level ... DB2 6
No new posts RC query -Time column CA Products 3
No new posts Help in extracting data between doubl... DFSORT/ICETOOL 5
No new posts first column truncated in search result IBM Tools 13
Search our Forums:

Back to Top