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
 

 

Find 5 continuous numeric data in a record

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Shrinika Rajendran

New User


Joined: 06 Jun 2013
Posts: 25
Location: India

PostPosted: Tue Dec 09, 2014 12:48 pm    Post subject: Find 5 continuous numeric data in a record
Reply with quote

Hi all,
I need to find records that have 5 numbers continuously. It is fine to find if the data is numeric in a particular position.

But, is it possible to somehow mention the number of numeric positions we are looking for in a record?

Thanks in advance
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Dec 09, 2014 2:49 pm    Post subject:
Reply with quote

I suggest that you take a step back and consider thinking about how best to ask your question.

So far it's about as clear as mud, so you probably will not get any help at all.

Think about how you would like someone else to explain their problem to you
Back to top
View user's profile Send private message
Shrinika Rajendran

New User


Joined: 06 Jun 2013
Posts: 25
Location: India

PostPosted: Tue Dec 09, 2014 3:38 pm    Post subject:
Reply with quote

I want to do numeric check on the fields. But not just at a particular position. But scan thru a particular length of record and find out if that record has five number continuously anywhere in that length.

Code:
----+----1----+----2
********************
121 MINT STREET
COL SD 4436 NATL HWY   
TAKE 18428 TULIP   


Here, I would want to check thru positions 1-20. The third record has 5 numbers. I want only this record.

Please let me know if you need any more details.

Thanks
Back to top
View user's profile Send private message
boyti ko

New User


Joined: 03 Nov 2014
Posts: 78
Location: Malaysia

PostPosted: Tue Dec 09, 2014 4:57 pm    Post subject:
Reply with quote

in command line, you can use
FIND P'#####'
and you will find that number
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Tue Dec 09, 2014 5:02 pm    Post subject: Reply to: Find 5 continuous numeric data in a record
Reply with quote

the TS wanted a jcl solution ( probably a <sort> solution )
Back to top
View user's profile Send private message
prino

Active Member


Joined: 07 Feb 2009
Posts: 982
Location: Oostende, Belgium

PostPosted: Tue Dec 09, 2014 5:02 pm    Post subject:
Reply with quote

Unless this is some (censored) homework request, what is the use of doing this?????
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Tue Dec 09, 2014 5:12 pm    Post subject: Reply to: Find 5 continuous numeric data in a record
Reply with quote

Robert,

what a silly question icon_wink.gif

You should already know that the reply would be ...

that' s the requirement


icon_biggrin.gif
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7228

PostPosted: Tue Dec 09, 2014 7:06 pm    Post subject: Reply to: Find 5 continuous numeric data in a record
Reply with quote

Shrinika Rajendran,

Can you show an example of what you want to do? I it still unclear.

For instance, we have no idea if you are looking for a particular five-digit number(s) or any old five-digit (or more) number will do.
Back to top
View user's profile Send private message
steve-myers

Active User


Joined: 30 Nov 2013
Posts: 461
Location: The Universe

PostPosted: Tue Dec 09, 2014 9:53 pm    Post subject:
Reply with quote

In the US, it would be to find records containing a postal code, though there will be a lot of false hits, especially in large cities like New York.
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
No new posts How to move a long alphanumeric data ... lind sh COBOL Programming 6 Mon Dec 05, 2016 7:51 pm
No new posts How to find the first monday of the w... abdulrafi COBOL Programming 10 Fri Nov 25, 2016 3:24 pm
No new posts How to update a portion of text in a ... Bill Woodger DFSORT/ICETOOL 25 Wed Nov 09, 2016 9:41 pm
No new posts ODPP(Optim Data privacy Provider) Iss... Rama kishore IBM Tools 1 Mon Nov 07, 2016 5:46 pm


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