pl/sql regex verification

Question

How to verify a string that only permits numbers letters and the characters like '.', '/', '_', '-' and only permit 40 characters.

I was doing something like this REGEXP_LIKE(path, '[a-zA-Z0-9_./-]{2,40}$') but is not working good.

Can anyone help me with this regex?

chaos · Accepted Answer · 2011-07-19 19:02:33Z

3

Well, it won't limit to 40 characters because it isn't anchored to the beginning of the string. Try:

REGEXP_LIKE(path, '^[a-zA-Z0-9_./-]{2,40}$')

Other than that I don't see anything glaringly wrong with it, assuming of course that you do mean for the minimum length to be 2 characters.

answered Jul 19, 2011 at 19:02

chaos

125k34 gold badges306 silver badges310 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

chaos Over a year ago

It won't limit to 40 without the ^ anchor because then it will match any time the 40 characters at the end of the string match; there could be 5K of gibberish before that and the regex would still find a match.

Kirill Polishchuk · Accepted Answer · 2011-07-19 19:03:25Z

2

May be you need to add beginning of line special character ^, i.e.: ^[a-zA-Z0-9_./-]{2,40}$

answered Jul 19, 2011 at 19:03

Kirill Polishchuk

56.4k11 gold badges125 silver badges127 bronze badges

Collectives™ on Stack Overflow

pl/sql regex verification

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related