On Thu, Sep 3, 2009 at 3:20 AM, John Weller<[email protected]> wrote: > I have done a lot of work importing data for a direct marketing company. As > they specialised in the entertainment field, particularly night clubs, much > of the data that was captured was entered late at night whilst the punter > had already had a few. I found that the best way to handle data such as > phone number was to initially define what sort of numbers would be valid. > If you are using them for a marketing campaign then extension numbers may > not be of use and so could be binned, equally ones without an area code; on > the other hand they may be valid - you need to define the rules first then > code them. Cleaning data such as names, addresses, phone numbers is not a > trivial task! I found the easiest way was to step through the number one > character at a time and use ISDIGIT(). -------------------------
You then have to scan through the data you think are numbers and pull out prank SMS Text statements as well as the 555-???? that not wasted people will give because they know better. -- Stephen Russell Sr. Production Systems Programmer SQL Server DBA Web and Winform Development Independent Contractor Memphis TN 901.246-0159 _______________________________________________ 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.
