What about taking care of the issue on the front end - at the user input. Use something like an input mask to prevent users from entering phone numbers that are invalid?
-----Original Message----- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Wednesday, September 02, 2009 17:24 To: profoxt...@leafe.com Subject: Re: How to detect if digits in phone field? Gene Wirchenko wrote: > 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. Thanks for the clarification, Gene. But you could have a situation where you have a partial number, but then again, you just can't protect against all kinds of bogus scenarios. It's the 80/20 rule...code for the 80%, deal with the 20%. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 [excessive quoting removed by server] _______________________________________________ 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/013a01ca2c16$403617f0$c0a247...@net ** 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.
