Normalizing Dates and Phone numbers

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 26724
interpreted = N
texte = 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 1212This 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 Associated Messages, from the most recent to the oldest:

    
  1. Re: Normalizing Dates and Phone numbers (Chuck Rice 2000)
  2. Re: Normalizing Dates and Phone numbers (Kenneth Grome 2000)
  3. Re: Normalizing Dates and Phone numbers (Chuck Rice 2000)
  4. Re: Normalizing Dates and Phone numbers (Chuck Rice 2000)
  5. Re: Normalizing Dates and Phone numbers (Kenneth Grome 2000)
  6. Re: Normalizing Dates and Phone numbers (Aaron Lynch 2000)
  7. Normalizing Dates and Phone numbers (Chuck Rice 2000)
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 1212This 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 Chuck Rice

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:

Sorting (1998) [WriteFile] problems (1997) [isfile] ? (1997) problem: search crashes webstar (1997) WebCat2 beta 11 - new prefs ... (1997) WebCat2b15MacPlugin - [protect] (1997) Affiliate Marketing Question #2 (1998) form crasehes server (1997) Showif = stumped? (2001) Authenticate and IIS (1997) [quantity] within formulas (1997) Calendar (1997) db updating? (2000) Errata: WCS Newbie question (1997) WebDNA Grep help wanted (2004) [WebDNA] Passing a text variable via copyfile (2019) Lost and Recovered. (1998) RE: WebDNA-Talk searchable? (1997) searching illegal HTML (2002) Version 2.0 and 1.6 simultaneous (1997)