At 11:04 2009-09-02, MB Software Solutions, LLC
<mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
>We've got some phone fields in a table, and I'm grabbing them for
>reporting purposes. Some users seem to have keyed in crap though, like
>no digits but a dash or parens here and there. I want to NOT grab these
>fields, so how best can I basically code (in VFP9SP2) something like this:
>
>* pseduocode
>if DigitsInPhoneField then
> grab the field
>else
> ignore it
>endif
So "876-5432 ext. 123", "ABC 123", and "Gene is #1." would be acceptable?
Your test could be
if chrtran(phonenbr,"0123456789","")#phonenbr
* has digit
else
* no digits
endif
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/20090902185327.ad58998...@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.
