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
 

 

Double quotes from one perticular column to another column

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CLIST & REXX
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    Post subject: Double quotes from one perticular column to another column
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

Site Director


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

PostPosted: Wed Nov 12, 2008 8:55 pm    Post subject:
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    Post subject:
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

Site Director


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

PostPosted: Thu Nov 13, 2008 10:43 am    Post subject:
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: 685
Location: Earth

PostPosted: Thu Nov 13, 2008 12:00 pm    Post subject:
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: 1239
Location: Richfield, MN, USA

PostPosted: Thu Nov 13, 2008 9:06 pm    Post subject:
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

Senior Member


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

PostPosted: Thu Nov 13, 2008 10:41 pm    Post subject: Reply to: Double quotes from one perticular column to anothe
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    IBMMAINFRAMES.com Support Forums -> CLIST & REXX All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2 query Using Recursion, Converting... smilewithashu2 DB2 1 Tue Jan 03, 2017 12:50 pm
No new posts SQZ pipe delimited file with 1 column... Rick Silvers DFSORT/ICETOOL 2 Sun Nov 06, 2016 8:11 pm
This topic is locked: you cannot edit posts or make replies. Checking wether a string starts from ... sundaram.naveen CLIST & REXX 9 Thu Oct 06, 2016 11:56 am
No new posts Add system date inside of a PS file a... pramitdas DFSORT/ICETOOL 5 Sun Aug 28, 2016 12:06 am
No new posts Converting NULL column into NOT NULL ... Raghu navaikulam DB2 5 Sat Aug 06, 2016 3:45 pm


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