Re: Convert Chars Q
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 35888
interpreted = N
texte = The problem is expecting Excel to be consistent! Proper CSV formatting is hard; numerics do not ever have surrounding quotes, but text fields may be surrounded by quotes and embedded quotes are quoted by a variety of means.I would stop using Excel entirely, because it is not suitable for use with a database. Use Access, which has a better export mechanism for CSV (you can define your export format better).John PeacockGary J. Krockover wrote: > > Peter (and Joe), > I wish it was surrounded with quotes...but from the output I get from the > Excel export, it is just: > field1,field2,field3,etc... > > Now, maybe it's my Office settings -or- the proper format for a CSV is to > have each field quoted (thus, you could have a plain comma in a field so > that it doesn't screw up the columns). That makes sense. But when I export > the tab-delimited to CSV and then open the .csv in BBEdit for example, it's > in the format I listed above. I've also been sending Storerunner her > webcat/Excel created .csv's and they've had no problems at all appending the > data to their master database. > > It's no real biggie guys, as I originally said, I was just trying to have > her click one button and then the file is totally done. The way it is now, > she just has to take the webcat created tab-delim file and change comma's to > the ascii equiv and then import-export via Excel. > > If someone has a quick and dirty answer, I'd appreciate it, I also would > appreciate any comments on the original code I first posted, but other than > that, don't worry too much about it :) > > Thanks, > G. > > > 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;field3 > > > > Then 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;field3 > > > > At 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/------------------------------------------------------------- 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:
The problem is expecting Excel to be consistent! Proper CSV formatting is hard; numerics do not ever have surrounding quotes, but text fields may be surrounded by quotes and embedded quotes are quoted by a variety of means.I would stop using Excel entirely, because it is not suitable for use with a database. Use Access, which has a better export mechanism for CSV (you can define your export format better).John PeacockGary J. Krockover wrote: > > Peter (and Joe), > I wish it was surrounded with quotes...but from the output I get from the > Excel export, it is just: > field1,field2,field3,etc... > > Now, maybe it's my Office settings -or- the proper format for a CSV is to > have each field quoted (thus, you could have a plain comma in a field so > that it doesn't screw up the columns). That makes sense. But when I export > the tab-delimited to CSV and then open the .csv in BBEdit for example, it's > in the format I listed above. I've also been sending Storerunner her > webcat/Excel created .csv's and they've had no problems at all appending the > data to their master database. > > It's no real biggie guys, as I originally said, I was just trying to have > her click one button and then the file is totally done. The way it is now, > she just has to take the webcat created tab-delim file and change comma's to > the ascii equiv and then import-export via Excel. > > If someone has a quick and dirty answer, I'd appreciate it, I also would > appreciate any comments on the original code I first posted, but other than > that, don't worry too much about it :) > > Thanks, > G. > > > 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;field3 > > > > Then 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;field3 > > > > At 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/------------------------------------------------------------- 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/
John Peacock
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:
Separate SSL Server (1997)
Questions To Answer (1997)
[WebDNA] eCommerce System Release (2018)
hiding links (1999)
shoppingcart reload qty (1997)
Date math (1997)
Safe command=append (1999)
SiteGuard Admin Feature ? (1997)
acrobat -> wc (1998)
4.0x on production server (2000)
FTP and [shell] (2003)
cookies (2004)
E-mail loop ! (1997)
RequiredFields template (1997)
WebCat and image maps (1997)
Me know logical no need (2002)
PIXO with cometsite ... and/or other plugins (1998)
WebCat Mac OS X and Encrypt Help Need (2000)
Search/sort in URL Was: GuestBook example (1997)
WebCat2b12plugin - [search] is broken ... not! (1997)