|
|
 | | RE: CSV delimiters
|
| (...) I agree. I was trying to hack an Excel file into some usable html, and those "" made it nearly impossible for me to do search and replaces to get valid html without messing it up in other places. --Bram Bram Lambrecht BXL34@po.cwru.edu (URL) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)
| | | | | Re: CSV delimiters
|
| (...) Eeek -- shame on me -- did I just say "it's" when I meant "its"? Anyway, I forgot to say: The idea of escaping quotes is *bizarre* in the first place. IMHO, there shouldn't *be* any closing double-quote character on a field once it has already (...) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)
| | | | | Re: CSV delimiters
|
| (...) I hate it too. IIRC, Excel uses "" instead of \" for an escaped " -- but I could be wrong. I just remember hating it once when I looked at it. :) One nice thing, though, is that Excel can import tab-delimited text, so that's it's saving grace. (...) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)
| | | | | RE: CSV delimiters
|
| (...) Sorry, I can't help. And I hate the way Excel outputs in plain text. But since it's 2:30 in the morning, I'll make useless comments. Sounds like you're working on the question I asked...augh, and I just entered all the sets manually. Oh well, (...) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)
| | | | | CSV delimiters
|
| Is there any "official" or "reasonably standardized format" for CSV (_C_omma _S_eparated _V_alue) data? I guess it's pretty obvious, mostly, but how are the delimiter characters typically encoded (specifically: comma, double-quote, and newline)? In (...) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)
|
|
