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
 

 

How to search a string in the range of particular columns.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> TSO/ISPF
View previous topic :: :: View next topic  
Author Message
NAGARJUN CARALAPATI

New User


Joined: 09 Oct 2007
Posts: 22
Location: chennai.India

PostPosted: Fri Oct 26, 2007 11:56 am    Post subject: How to search a string in the range of particular columns.
Reply with quote

I want to search a particular string in all the lines of the dataset. But only in the wanted columns.

i.e i want to search the string only in the column range 4 to 10. It means that even my string is present in other columns, im not bothered, i want my search string to be found only in the 4,5,6,7,8,9,10 th columns only.

Can anyone help on this !
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10232
Location: italy

PostPosted: Fri Oct 26, 2007 12:06 pm    Post subject: Reply to: How to search a string in the range of particular
Reply with quote

ISPF help will help,
also reading the manual

anyhow here is a hint

Quote:
f "from_string" 4 10


Quote:
c "from_string" "to_string" 4 10
Back to top
View user's profile Send private message
NAGARJUN CARALAPATI

New User


Joined: 09 Oct 2007
Posts: 22
Location: chennai.India

PostPosted: Fri Oct 26, 2007 12:18 pm    Post subject:
Reply with quote

E.S,

Thank u very much, it worked !!!!!!!!
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10232
Location: italy

PostPosted: Fri Oct 26, 2007 12:19 pm    Post subject: Reply to: How to search a string in the range of particular
Reply with quote

Quote:
Thank u very much, it worked !!!!!!!!


Never doubted ! :-)
Back to top
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1288
Location: Chennai, India

PostPosted: Fri Oct 26, 2007 12:37 pm    Post subject: Reply to: How to search a string in the range of particular
Reply with quote

You can also use the below mentioned command.

Code:
F ALL 'string' 4 10


This would also display the no of occurences of the string inaddition to the search.
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Fri Oct 26, 2007 5:03 pm    Post subject:
Reply with quote

Also, you can pre-set the bounsaries using the BNDS command.

O.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Oct 26, 2007 5:46 pm    Post subject:
Reply with quote

Hi O,

I think, BNDS is a line command & will be active through out the session (for the that profile in which it's used) ? Please let me know.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10232
Location: italy

PostPosted: Fri Oct 26, 2007 6:17 pm    Post subject: Reply to: How to search a string in the range of particular
Reply with quote

the only unpleasant issue with bnds is that it must be manually reset
if You forget, You will end up with change/find misleading info
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Oct 29, 2007 1:36 pm    Post subject:
Reply with quote

Yeah this happened to me once..& then I wasted nearly half day just to get rid of the 'stupid' looks os my ISPF screen. (Coz once I shared my RACF ID/password with someone here..I was dumb enough..! icon_redface.gif )
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 -> TSO/ISPF All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts outrec field outside range Danielle.Filteau SYNCSORT 10 Sat Mar 04, 2017 2:37 am
No new posts Replacing same string with different ... vickey_dw DFSORT/ICETOOL 6 Wed Feb 22, 2017 10:44 pm
No new posts Count Trailing Spaces in variable str... Virendra Shambharkar SYNCSORT 10 Thu Feb 02, 2017 12:23 pm
This topic is locked: you cannot edit posts or make replies. Db2 SQL query to convert rows into co... subratarec DB2 5 Thu Nov 17, 2016 4:51 pm
No new posts Comparing Decimal and CHAR columns rakesh17684 DB2 7 Thu Oct 20, 2016 2:33 am


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