Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Regular Expression in APEX

V RickertJun 16 2015 — edited Jun 18 2015

Hello all!

I'm need a relatively simple Regular Expression for an APEX validation and I am getting nowhere!

I need a regular expression that validates that the contents of a variable is in the following form:

ABC1234567

where the first three characters are capital letters and the next 7 are numeric.  THe field must be 10 characters long.

Can anyone please help.  I am so frustrated; this can't be so hard!

My validation was:

^([A-Z]{3}[0-9]{7})$ but the validation does not work.

When I leave it at:

^([A-Z]{3}[0-9]{7}) without the $ sign at the end, and it ignores the required 7 digits.

Any ideas?
Thank you!

This post has been answered by ReemaPuri on Jun 17 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 15 2015
Added on Jun 16 2015
26 comments
5,992 views