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:
AOL and referrers on target=_blank (2000)
possible, WebCat2.0 and checkboxes-restated (1997)
vcode (2003)
WebCatalog for guestbook ? (1997)
limitation found on group searching (1997)
Line items in table cells (1997)
No luck with taxes (1997)
Keep away (1997)
Error 11 (1996)
Frustration with formulas.db (1999)
Authenticate (1997)
Testing, Sorry (1998)
Help formatting search results w/ table (1997)
RE: Signal Raised (1997)
lookup problem (2000)
Country & Ship-to address & other fields ? (1997)
HideIf ip= OR ip (1998)
WebCatalog and Filemaker (1996)
Help! WebCat2 bug (1997)
RAM variables (1997)