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:

Resume Catalog ? (1997) Forms Search Questions (1997) WebCat control of Print (2001) Empty Shopping Carts? (1998) RequiredFields template (1997) Shared Webstar Directory (1998) WebCat 4.0 & WebMerchant (2000) [showif]/[hideif] question (1997) [lineitems] and [writefile] (1998) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) 2.0.1 new commands and contexts (1997) To Use Cookies or Not To Use Cookies (2003) credit card (1997) A little syntax help (1997) Test (2003) Seattle based Webcatters? (2000) SSL and reg web* (1997) multiple search commands (1997) WebCat2 beta 11 - new prefs ... (1997) [WebDNA] Quick grep... Govinda?? (2010)