Re: Normalizing Dates and Phone numbers
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 26725
interpreted = N
texte = sure, use a custom [convertchars] db to strip out everything that's not a number, and then add in hyphens or whatever where ever you want with countchars-AaronChuck Rice wrote: > > Newbie here. Pardon and point me if this is a FAQ somewhere. > > I want to normalize dates and phone numbers as they are entered into > the database. Some people enter phone numbers as: > > 408-555-1212 > (408)555-1212 > 408/555-1212 > 1-(408)555-1212 > 555-1212 > 408 555 1212 > > This turns into a bit of a mess. Is there some neat trick for > converting all of these to one format during input before they get > added to the database? I could set up separate fields, but that is > not much better. > > Same thing for the date. > > If there is not, it sure would make a good enhancement to add such a > WebCat Tag. -Chuck- > > __________________________________________________________________________ > Chuck Rice
> > > > > ------------------------------------------------------------- > Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. > To end your Mail problems go to . > > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
sure, use a custom [convertchars] db to strip out everything that's not a number, and then add in hyphens or whatever where ever you want with countchars-AaronChuck Rice wrote: > > Newbie here. Pardon and point me if this is a FAQ somewhere. > > I want to normalize dates and phone numbers as they are entered into > the database. Some people enter phone numbers as: > > 408-555-1212 > (408)555-1212 > 408/555-1212 > 1-(408)555-1212 > 555-1212 > 408 555 1212 > > This turns into a bit of a mess. Is there some neat trick for > converting all of these to one format during input before they get > added to the database? I could set up separate fields, but that is > not much better. > > Same thing for the date. > > If there is not, it sure would make a good enhancement to add such a > WebCat Tag. -Chuck- > > __________________________________________________________________________ > Chuck Rice > > > > > ------------------------------------------------------------- > Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. > To end your Mail problems go to . > > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Aaron Lynch
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Hard Questions ? (1997)
Click-through/Referral tracking solution needed (2000)
Counting LineItems (2000)
Summing fields (1997)
OK, here goes... (1997)
SERIAL NUMBER PROBLEM *AGAIN*!!! (1998)
WordBreak Qestion (1998)
WebCat2 several catalogs? (1997)
Improved ISAPI extension (2004)
WebCat Admin access w/ClearlyHome p.i. (1997)
VeriSign News (2002)
New public beta available (1997)
New Guestbook Source (1997)
WebDelivery downloads alias, not original ? (1997)
Stopping a [Loop] in mid-stream ... (1997)
Proper file locations (1997)
The IBC root beer has arrived! (1997)
WebDNA security (2004)
comparison to Lasso 6 or 7 (2004)
[Listfiles] vs Netfinder (1997)