[SOLVED] REGEX Pain / Problem

PointsWell

I am trying to build a Validate As regex for telephone numbers (specifically that they only contain numbers and notation elements - i.e. not characters and not tabs etc) - so I tried first with /[\d ().-]/ and that didn't work even though when I test it at Regex101.com it validates correctly.

After some head scratching and testing and validating (because I find regex hard), I then went to first principles and cut and paste the example expression from p173 of the User Guide

/\\(?\\d{3}\\)? ?\\d{3}[-.]\\d{4}/

And something peculiar happened, the Create button on my form suddenly becomes disabled.

Which makes me wonder if my regex was ok to start with or whether there is a problem with Validate As regex?

hpl123

Regex in Aware is a real pain and I have had the same results many times i.e all external regex tests validate correctly but in Aware it doesn't work. It might be Aware handles it differently in some way.

Support, a video about this would be really helpful as regex is a great tool if we can use it correctly in Aware.

Regarding the phone no regex, here is a simple one I use and might be enough for your needs:
Regex for int phone no (simplified) + regex tester (comment)&hilit=Regex+phone#p41222

PointsWell

Thanks, I’d checked out your example when I was trying to figure this out, but my issue is that users are entering spaces between numbers, parentheses round groups of numbers etc etc.

Which is why I was trying to get [\d .()-] to work...

Jaymer

I use the Input Mask for US Phone #s:
Screen Shot 2018-05-25 at 10.46.52 AM.png

Its too bad this doesn't allow a derived/calculated input mask.
I have the Luxury of only allowing US phone #s.

Would be nice if you could do:
If Lead.Country = 'US' THEN Mask='999-999-9999'
If Lead.Country = 'GB' THEN Mask='99-99-9999-999' (or whatever they use)

And then the next logical step would be to use a Query (like Choices are determined at Runtime) so this doesn't have to be hardcoded and a simple BO could hold the formats for all the phone #s you need.

BobK

You were SOOOOOO close.

Your Regex is checking for only 1 character. To check for 1 or more characters use the following:
/[\d ().-]+/

You can also check for a specific number of characters or a range of number of characters.

The following will check for at least 7 but not more then 14 characters:
/[\d ().-]{7,14}/

PointsWell

Jaymer wrote
.

Would be nice if you could do:
If Lead.Country = 'US' THEN Mask='999-999-9999'
If Lead.Country = 'GB' THEN Mask='99-99-9999-999' (or whatever they use)

REST is your friend https://numverify.com

PointsWell

BobK wrote
You were SOOOOOO close.

BobK that fixed it. Thanks!

Wonder what’s going wrong with the example that’s copied from the user guide?