SPUG: Perl shines for data validation

Callan, Chris Chris.Callan at Tectura.com
Fri Dec 11 06:45:31 PST 2009


If it's the only tool/language available for the processing, then it is
what it is.  


Chris Callan 

"When your map and the terrain disagree, believe the terrain."

~Military quote on "Ground Truth" and navigation

3:80 


-----Original Message-----
From: spug-list-bounces+chris.callan=tectura.com at pm.org
[mailto:spug-list-bounces+chris.callan=tectura.com at pm.org] On Behalf Of
Michael R. Wolf
Sent: Thursday, December 10, 2009 7:53 PM
To: Spug-List at Pm.Org
Subject: SPUG: Perl shines for data validation

I just saw this as a suggestion to flag invalid phone numbers as a  
validation routine for importing into a hosted database application.

I think they were serious.

LEN(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(MobilePhone, "(", ""), ")", ""), "-",""),"  
",""),".",""),"/","")) <> 10


Eeeeekk.  SQL is not the right tool for this job.

-- 
Michael R. Wolf
     All mammals learn by playing!
         MichaelRWolf at att.net




_____________________________________________________________
Seattle Perl Users Group Mailing List
     POST TO: spug-list at pm.org
SUBSCRIPTION: http://mail.pm.org/mailman/listinfo/spug-list
    MEETINGS: 3rd Tuesdays
    WEB PAGE: http://seattleperl.org/


No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 9.0.709 / Virus Database: 270.14.103/2558 - Release Date:
12/11/09 02:06:00



More information about the spug-list mailing list