Re: Convert Chars Q

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 35864
interpreted = N
texte = on 08.08.2000 3:33, Gary J. Krockover at gkrockover@austin.rr.com wrote:> Anyways, I just want it to > convertchars from a comma to ascii if it finds one in a field so that when I > do import the newly appended .db to Excel for export to CSV, a comma in her > description field for example doesn't become a column seperator.Isn't CSV this format: field1,field2,field3 or this field1;field2;field3Then it might work if you simply surround *any* field with quotes. So you should be able to handle quotes within fields also: field1;field2 is has quotes inside;field3At least this is what I get from clients sometimes... Of course, you should convert special chars and semicolons within fields. 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:

    
  1. Re: Convert Chars Q (John Peacock 2000)
  2. Re: Convert Chars Q (Peter Ostry 2000)
  3. Re: Convert Chars Q (Gary J. Krockover 2000)
  4. Re: Convert Chars Q (Peter Ostry 2000)
  5. Re: Convert Chars Q (Joseph D'Andrea 2000)
  6. Re: Convert Chars Q (Gary J. Krockover 2000)
  7. Re: Convert Chars Q (Joseph D'Andrea 2000)
  8. Re: Convert Chars Q (Gary J. Krockover 2000)
  9. Re: Convert Chars Q (Joseph D'Andrea 2000)
  10. Convert Chars Q (Gary J. Krockover 2000)
on 08.08.2000 3:33, Gary J. Krockover at gkrockover@austin.rr.com wrote:> Anyways, I just want it to > convertchars from a comma to ascii if it finds one in a field so that when I > do import the newly appended .db to Excel for export to CSV, a comma in her > description field for example doesn't become a column seperator.Isn't CSV this format: field1,field2,field3 or this field1;field2;field3Then it might work if you simply surround *any* field with quotes. So you should be able to handle quotes within fields also: field1;field2 is has quotes inside;field3At least this is what I get from clients sometimes... Of course, you should convert special chars and semicolons within fields. 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:

What file? (1997) What is WebDNA (1997) OT: a little server help needed (2003) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) Running _every_ page through WebCat ? (1997) Two prices in shoppingcart? (1997) [WebDNA] CMS in WEBDNA (2009) Bug Report, maybe (1997) Re:One more time (1997) Refering page (1998) FTP and [shell] (2003) Fw: [SQL] and [index] mystery solved (2001) Re:Searching for ALL / empty form field (1997) WebMerchant 1.6 and SHTML (1997) Re:quit command on NT (1997) login via cookies (2006) emailer cc to figured out (1997) [WriteFile] problems (1997) Calculating multiple shipping... (1997) New command suggestion (was Modifying databases manually) (1997)