Re: Pipes instead of tabs

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 18589
interpreted = N
texte = Ken,Why wouldn't this work:[writefile tabfile.db][convertchars db=pipeconversion.db][incude pipedfile.db][/convertchars][/writefile]Pipe delimination is not all that uncommon for databases. I have encountered numerous examples.Where pipeconversion.db is: from to | %09 Steve >>Is there anyway to make WebCatalog recognize pipes(|) instead of tabs in >>database delimination? > >Not right now, because a pipe is NOT a standard delimiter as far as >text-based database files are concerned. The industry standards for >delimitation of database fields in text files are tabs or commas ... but >you can easily use BBEdit or Tex-Edit to replace all the pipes with tabs >in your database, then you will have a format that WebCatalog (and nearly >every other database program in the world) can use directly, or import ... >:) > >Sincerely, >Ken Grome >808-737-6499 >WebDNA Solutions >mailto:ken@webdna.net >http://www.webdna.net ----------------------------------------------------------------------- Steve Rosenbaum Pop Art L.L.C. http://pop-art.com steve@pop-art.com Networks / Databases / Multimedia7000 SW Hampton St., Suite 124, tel: (503) 968.5957 Tigard, OR 97223-8361 fax: (503) 620.8487 Associated Messages, from the most recent to the oldest:

    
  1. Re: Pipes instead of tabs (Kenneth Grome 1998)
  2. Re: Pipes instead of tabs (Steve Rosenbaum 1998)
  3. Pipes instead of tabs (josh 1998)
  4. Re: Pipes instead of tabs (Kenneth Grome 1998)
  5. Re: Pipes instead of tabs (PCS Technical Support 1998)
Ken,Why wouldn't this work:[writefile tabfile.db][convertchars db=pipeconversion.db][incude pipedfile.db][/convertchars][/writefile]Pipe delimination is not all that uncommon for databases. I have encountered numerous examples.Where pipeconversion.db is: from to | %09 Steve >>Is there anyway to make WebCatalog recognize pipes(|) instead of tabs in >>database delimination? > >Not right now, because a pipe is NOT a standard delimiter as far as >text-based database files are concerned. The industry standards for >delimitation of database fields in text files are tabs or commas ... but >you can easily use BBEdit or Tex-Edit to replace all the pipes with tabs >in your database, then you will have a format that WebCatalog (and nearly >every other database program in the world) can use directly, or import ... >:) > >Sincerely, >Ken Grome >808-737-6499 >WebDNA Solutions >mailto:ken@webdna.net >http://www.webdna.net ----------------------------------------------------------------------- Steve Rosenbaum Pop Art L.L.C. http://pop-art.com steve@pop-art.com Networks / Databases / Multimedia7000 SW Hampton St., Suite 124, tel: (503) 968.5957 Tigard, OR 97223-8361 fax: (503) 620.8487 Steve Rosenbaum

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:

listfiles-looking for slick solution (1997) Setting up shop (1997) WebCatalog seems to choke on large (2meg) html files. (1998) MacActivity and PCS (1997) Summing fields (1997) return missing item (was:WebCat Sales) (1997) Looking for a host (1997) Summing fields (1997) OT - royalty free images (2002) Quiz question: Return all green and blank records? (2001) New WebCatalog site (1997) WebCat2: Items xx to xx shown, etc. (1997) Large databases in WebCat (1997) WebCatalog Prefs.ref file ? (1998) WebCat hosting providers? - one more option (1997) syntax question, not in online refernce (1997) MacAuthorize and WebMerchant (1997) Separate SSL Server (1997) [WebDNA] Error: template... (2009) remotely add + sign (1997)