Re: Strange database format import
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 27780
interpreted = N
texte = On 2/17/00 11:29 pm, Dennis J. Bonsall, Jr. so noted...>WebCat seems to do okay with it up until a point. The database is a >comma-delimited database, and the first several columns are denoted by >quotes and seperated by commas. Even when it gets to a point where >commas appear within the quotes, WebCat does not have a problem. But, >when it gets to the last several colums of the database, which have no >quotes, and are separated only by commas, WebCat chokes on the >database. Here is an entry from within this database: > >CANADA,01/01/00 - 12/31/00,2-A,SME,Wool Suits, >M&B,5016780,20330,0.40524,0.064045,0.06754,0.,01/13/00The file is *close* to being quote/comma delimited, until you get to the last part. As long as this inconsistent format is consistent (quote/comma at the beginning, numbers with commas at the end) you can do a replace in BBEdit.Grep pattern to search for: ([\d\.]),([\d\.])and to replace with: \1,\2Then, to finish off the last item, You'll need to search for \r and replace with \r throughout.Rob Marquardt Designer/Resident Wirehead Toast Design800 Washington Avenue North Minneapolis MN 55401 612.330.9863 v 612.321.9424 f www.toastdesign.com ------------------------------------------------------------- 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:
On 2/17/00 11:29 pm, Dennis J. Bonsall, Jr. so noted...>WebCat seems to do okay with it up until a point. The database is a >comma-delimited database, and the first several columns are denoted by >quotes and seperated by commas. Even when it gets to a point where >commas appear within the quotes, WebCat does not have a problem. But, >when it gets to the last several colums of the database, which have no >quotes, and are separated only by commas, WebCat chokes on the >database. Here is an entry from within this database: > >CANADA,01/01/00 - 12/31/00,2-A,SME,Wool Suits, >M&B,5016780,20330,0.40524,0.064045,0.06754,0.,01/13/00The file is *close* to being quote/comma delimited, until you get to the last part. As long as this inconsistent format is consistent (quote/comma at the beginning, numbers with commas at the end) you can do a replace in BBEdit.Grep pattern to search for: ([\d\.]),([\d\.])and to replace with: \1,\2Then, to finish off the last item, You'll need to search for \r and replace with \r throughout.Rob Marquardt Designer/Resident Wirehead Toast Design800 Washington Avenue North Minneapolis MN 55401 612.330.9863 v 612.321.9424 f www.toastdesign.com ------------------------------------------------------------- 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
Rob Marquardt
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:
A quickie question (1997)
Encrypt (2000)
More on the email templates (1997)
RE:DatabaseHelper (1997)
same bill to and ship to? (1998)
RE: type 2 errors with ssl server (1997)
Develop on Mac - Serve on Linux (2002)
Anybody see this before? (2006)
Questions about maximum (1999)
Lost and Recovered. (1998)
PCS Frames (1997)
Security Issues and WebCommerce Solution (1997)
Loss in form (1998)
This list needs a digest: rant, rave... (1997)
Almost a there but..bye bye NetCloak (1997)
multiple search commands (1997)
triggers.db (1999)
Database Structuring (again) (2003)
Summary layout (1997)
SSL problems (1998)