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: 10292
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

Senior Member


Joined: 07 Feb 2009
Posts: 1032
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: 10292
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: 7315

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 Member


Joined: 30 Nov 2013
Posts: 546
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 Select numeric portion from CHAR data... balaji81_k DB2 5 Sat Aug 19, 2017 1:51 am
No new posts Command to find TMEMBER name for a TPIPE Siva NKK Kothamasu IMS DB/DC 0 Wed Aug 16, 2017 6:08 pm
No new posts Unable to copy data from spool in a d... srikant314 JCL & VSAM 8 Fri Jul 28, 2017 9:10 pm
No new posts Paasing symbolic parameter to instrea... Robert Sample JCL & VSAM 2 Thu Jul 27, 2017 1:22 pm
No new posts Passing data from REXX to C programme... chong.zhou CLIST & REXX 3 Wed Jul 26, 2017 9:11 pm


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