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:
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:
converting characters in form (1997)
carriage returns in data (1997)
Math Problem - Format? (1997)
Writing [raw] to a file (2000)
Design Help Needed (1998)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
price formula (1999)
Running 2 two WebCatalog.acgi's (1996)
founditem align (1998)
typhoon... (1997)
[delete] problem (1997)
[include] and not found (2005)
Comments in db? (1997)
RE: [WebDNA] IIS 6.0 Custom Errors & WebDNA 6.2 (2009)
Bug (feature) in v6 listfiles shows hidden files ... (2004)
Re1000002: Setting up shop (1997)
RE: [WebDNA] Use of MySQL with WebDNA (2010)
WebDNA Solutions ... (1997)
displaying New products (Yikes! it's Fixed!) (1997)
Me know logical no need (2002)