In addition to Frank's suggestion, you can use ISDIGIT to walk the string or use regex.
rk -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MB Software Solutions, LLC Sent: Wednesday, September 02, 2009 2:04 PM To: [email protected] Subject: How to detect if digits in phone field? 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! _______________________________________________ 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/df1eef11e586a64fb54a97f22a8bd0440658a09...@ackbwddqh1.artfact.local ** 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.
