Find 5 continuous numeric data in a record

Shrinika Rajendran · New User Joined: 06 Jun 2013 Posts: 25 Location: India

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

expat · Posted: Tue Dec 09, 2014 2:49 pm

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

Shrinika Rajendran · New User Joined: 06 Jun 2013 Posts: 25 Location: India

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.

boyti ko · New User Joined: 03 Nov 2014 Posts: 78 Location: Malaysia

in command line, you can use
FIND P'#####'
and you will find that number

enrico-sorichetti · Posted: Tue Dec 09, 2014 5:02 pm

the TS wanted a jcl solution ( probably a <sort> solution )

prino · Posted: Tue Dec 09, 2014 5:02 pm

Unless this is some (censored) homework request, what is the use of doing this?????

enrico-sorichetti · Posted: Tue Dec 09, 2014 5:12 pm

Robert,

what a silly question

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

that' s the requirement

Bill Woodger · Posted: Tue Dec 09, 2014 7:06 pm

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.

steve-myers · Posted: Tue Dec 09, 2014 9:53 pm

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.