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