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:
Multiple catalog databases and showcart (1997)
[WebDNA] Permissions on DB files (2012)
Help name our technology! (1997)
New public beta available (1997)
webCatalog and Stocks (1998)
LookUp Tag (1997)
WebCatalog for guestbook ? (1997)
RE: Help name our technology! (1997)
RE: type 2 errors with ssl server (1997)
RE: 2nd WebCatalog2 Feature Request (1996)
Persistant Connections (2000)
How do I get multiple unique numbers on one template? (2000)
wc 2 pro users - sites, quotes wanted (1997)
Nested Loops and SHOWIFs (1997)
Webcatalog and Webstar V (2001)
Still having math problems (1997)
Multiple database search q -- Web Catalog 2.1 (2000)
Custom Error Pages - what I've done (1998)
MasterCounter Weirdness (1997)
Mac Vs WindowsNT (1997)