Re: Quotation Marks in Database

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 19418
interpreted = N
texte = >I have a client that wants to create a site that allows paid users to track >their investment portfolios. The three tab delimited databases he has >supplied me with have quotation marks (like this) around each field name >and around some of the actual data fields. Will this be a problem?Normally when a desktop database or spreadsheet program exports a text file, it has an option to use quotes or to NOT use quotes around each field. NOT using quotes will make your life a whole lot easier in the long run, so it's probably a good idea for you to:1- Get rid of the quotes yourself by using Tex-Edit or BBEdit on the files your client sends you, or ...2- Ask your client to send you tab-delimited files WITHOUT quotes. If he's using a program that can export without quotes (and most can) then he can easily make this change for you.Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Associated Messages, from the most recent to the oldest:

    
  1. Re: Quotation Marks in Database (Angel Bennett 1998)
  2. Quotation Marks in Database (Angel Bennett 1998)
  3. Re: Quotation Marks in Database (Kenneth Grome 1998)
  4. Re: Quotation Marks in Database (Kenneth Grome 1998)
>I have a client that wants to create a site that allows paid users to track >their investment portfolios. The three tab delimited databases he has >supplied me with have quotation marks (like this) around each field name >and around some of the actual data fields. Will this be a problem?Normally when a desktop database or spreadsheet program exports a text file, it has an option to use quotes or to NOT use quotes around each field. NOT using quotes will make your life a whole lot easier in the long run, so it's probably a good idea for you to:1- Get rid of the quotes yourself by using Tex-Edit or BBEdit on the files your client sends you, or ...2- Ask your client to send you tab-delimited files WITHOUT quotes. If he's using a program that can export without quotes (and most can) then he can easily make this change for you.Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Kenneth Grome

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:

Euro WebDNA Conference (2004) WebCatalog NT beta 18 problem (1997) Founditems (1998) 2.0 Info (1997) cart ID (1998) Re:quit command on NT (1997) WebCatalog2 Feature Feedback (1996) RE: WebCat cannot handle compatible search parameters? (1997) slightly OT: advertising schemes (2004) Exclamation point (1997) WebCatalog on Linux (2000) Problems with [Applescript] (1997) UPS charges (2000) Re[2]: Enhancement Request for WebCatalog-NT (1996) Help! WebCat2 bug (1997) Hiding HTML and page breaks (1997) [WriteFile] problems (1997) Price Not Appearing (2000) WebMerchant 1.6 and SHTML (1997) Emailer Error 472? (2004)