You can use CHRTRAN() to strip unwanted characters and test if it is empty after that:
PhoneNumber = "123(@3^%%" ?EMPTY(CHRTRAN(PhoneNumber, "!...@#$%^&*()", "")) MB Software Solutions, LLC 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 > > tia! > > -- Frank. Frank Cazabon Samaan Systems Ltd. - Developing Solutions www.SamaanSystems.com/ Referrals are important to us. If you know of anyone who would benefit from our services, please contact me. We would appreciate the opportunity to work with them. _______________________________________________ Post Messages to: [email protected] 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/[email protected] ** 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.
