At 12:04 2009-09-02, MB Software Solutions, LLC
<mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
>Tracy Pearson wrote:
> > I compare lengths to see if there were any digits
> >
> > len(chrtran(alltrim(field),"0123456789","")) <> len(alltrim(field))
>
>I like this approach the best....will add the '-' to it in case they've
>stored that as well (and I think most have). That would exclude the
>ones with "1-800-555-1212 ext 123" though. I guess I could add a
>separate check for "ext" $ lower(phonenumber) and allow it if that's the
>case.
Adding checks for "-" and "ext" is unnecessary.
You are misreading the code.
The condition means
if there is at least one digit in field
alltrim field.
Remove all digits.
Compare the length of resulting string to the length of alltrimmed field.
If the two lengths differ, allow the phone number.
If they are the same, then no digits were present to be removed: reject.
Sincerely,
Gene Wirchenko
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/20090902211708.9845a98...@marge.leafe.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
