phone number of area code (1 Viewer)

yanliang

New member
Local time
Today, 10:12
Joined
Sep 10, 2020
Messages
7
I ran into a problem where I need to find those who did not enter an area code for phone numbers.
(626)421-3459 is correct
but some are ()421-2459, are the one I need to find.
how to find those who those.
 

Gasman

Enthusiastic Amateur
Local time
Today, 14:12
Joined
Sep 21, 2011
Messages
14,053
Try Mid(field,2,1)=")"
 

namliam

The Mailman - AWF VIP
Local time
Today, 15:12
Joined
Aug 11, 2003
Messages
11,696
Like "()%"
left(field,2) = "()"
len(field) <= 10
Just to offer a few ideas
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 10:12
Joined
Feb 19, 2002
Messages
42,983
Look at your input mask. Is it set to store the separator characters or not?

To find the missing area codes, I would use the len() function.

Iif(len(yourphone)) <> 10 Then ''if the special characters are NOT stored
Iif(len(yourphone)) <>13 Then '' if the special characters are stored
 

Users who are viewing this thread

Top Bottom