Re: Normalizing Dates and Phone numbers
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 26727
interpreted = N
texte = At 5:00 PM -1000 2000/01/29, Kenneth Grome wrote:>Here, use this database with the convertchars context. It will get rid of everything that's not a number, then you can format the resulting string of digits with some getchars contexts ... or you can leave the resulting string as it is, which will result in 4085551212 based on your examples above:Thanks! Here is what I came up with. Seems to handle most cases. -Chuck-[!] [\!][GetChars start=8&end=10&from=end]00000000000[ConvertChars db=Strip.db][var1][/ConvertChars][/GetChars]-[!] [\!][GetChars start=5&end=7&from=end]00000000000[ConvertChars db=Strip.db][var1][/ConvertChars][/GetChars]-[!] [\!][GetChars start=1&end=4&from=end]00000000000[ConvertChars db=Strip.db][var1][/ConvertChars][/GetChars] __________________________________________________________________________ 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:
At 5:00 PM -1000 2000/01/29, Kenneth Grome wrote:>Here, use this database with the convertchars context. It will get rid of everything that's not a number, then you can format the resulting string of digits with some getchars contexts ... or you can leave the resulting string as it is, which will result in 4085551212 based on your examples above:Thanks! Here is what I came up with. Seems to handle most cases. -Chuck-[!] [\!][GetChars start=8&end=10&from=end]00000000000[ConvertChars db=Strip.db][var1][/ConvertChars][/GetChars]-[!] [\!][GetChars start=5&end=7&from=end]00000000000[ConvertChars db=Strip.db][var1][/ConvertChars][/GetChars]-[!] [\!][GetChars start=1&end=4&from=end]00000000000[ConvertChars db=Strip.db][var1][/ConvertChars][/GetChars] __________________________________________________________________________ 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:
Add - optional parameters textA=.... (1997)
Exclamation point (1997)
Cart Question: The Epic Saga (1998)
OT - Public Upload Security (2002)
WC2b15 File Corruption (1997)
how many tags? (2001)
Search returns all, not 20 (1997)
WebCatalog2 Feature Feedback (1996)
New Site Announcement (1998)
PCS Frames (1997)
Re:multiple digests, please stop (1997)
[WebDNA] max-age (2016)
Adding Header Values with [SetHeader] (1998)
Logging purchases (1997)
Calendar Snippet Available (1998)
Emailer (1997)
carriage returns in data (1997)
[writefile] (1997)
[WebDNA] WebDNA Hosting (2008)
I'm Sorry - OFF TOPIC (2000)