Re: Convert Chars Q
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 35868
interpreted = N
texte = on 08.08.2000 4:11, Gary J. Krockover at gkrockover@austin.rr.com wrote:> I wish it was surrounded with quotes...but from the output I get from the > Excel export, it is just: > field1,field2,field3,etc... I'm a bit confused - who gets what from which program :) But I had a look on Excel's CSV export and found that my guess was wrong, just just wrapping everything into quotes won't do. But the difference isn't big:Standard CSV format is one;two;three Spaces within fields change nothing.If you have quotes within fields, the exported field is wrapped into quotes and each quote inside the field changes to 2 quotes: my dear this is working yes converts to: my dear;this is working;yesFor me, it seems to be clear - write the export file basicly with this code: [search...] [writefile export.txt][founditems] [convertchars db=export.db][field1][/convertchars] [convertchars db=export.db][field2][/convertchars] [/founditems][/writefile] [/search]Note: In reality all your fields after [founditems] must be on one line, only [/founditems] produces a linefeed!Your export.db: from to ...and all your special chars, if there are some...Peter ------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
on 08.08.2000 4:11, Gary J. Krockover at gkrockover@austin.rr.com wrote:> I wish it was surrounded with quotes...but from the output I get from the > Excel export, it is just: > field1,field2,field3,etc... I'm a bit confused - who gets what from which program :) But I had a look on Excel's CSV export and found that my guess was wrong, just just wrapping everything into quotes won't do. But the difference isn't big:Standard CSV format is one;two;three Spaces within fields change nothing.If you have quotes within fields, the exported field is wrapped into quotes and each quote inside the field changes to 2 quotes: my dear this is working yes converts to: my dear;this is working;yesFor me, it seems to be clear - write the export file basicly with this code: [search...] [writefile export.txt][founditems] [convertchars db=export.db][field1][/convertchars] [convertchars db=export.db][field2][/convertchars] [/founditems][/writefile] [/search]Note: In reality all your fields after [founditems] must be on one line, only [/founditems] produces a linefeed!Your export.db: from to ...and all your special chars, if there are some...Peter ------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/
Peter Ostry
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:
hmmm (2006)
ShippingCosts (1998)
Need help with emailer- 2 issues (1997)
Two submit buttons ? (1997)
WebCat2 - storing unformatted date data? (1997)
Version f1 status (1997)
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
Newbie problem blah blah blah (1997)
Limitations on fields? Server is crashing (1997)
redirect with frames (1997)
WebCat2: multiple currency support (1997)
Running a store on BOTH http and https (1998)
PCS Emailer's role ? (1997)
Not really WebCat (1997)
Pricelist (1999)
[WebDNA] External email server/service? (2016)
Re:Password Authentication - request example (1998)
WebCat2b12 - nesting [tags] (1997)
FAX orders (1996)
Expanding the Product Database (2000)