The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
When I think of CSV, I am usually referring to any character-delimited text, of which the comma ranks well down on the list of preferred delimiter characters. I much prefer the vertical bar, "|" ASCII code 0x7c, or the TAB character, ASCII code 0x09.
1) The advantage of the vertical bar that it almost never occurs in normal text.
2) The advantage of the tab is that it is trivially easy to export well-formed rows (lines) of tab-separated values from many databases and accounting applications, and they are the default import delimiter in Microsoft Excel.
I emphasized the import delimiter in connection with Excel to differentiate it from opening CSV files into Excel, since opening a CSV bypasses the import wizard, with frequently unwanted, if not outright distastrous, results.
David A. Gray
Delivering Solutions for the Ages, One Problem at a Time
Interpreting the Fundamental Principle of Tabular Reporting
your point is taken, though for my needs this solution worked fine - with the caveat that it's only used in a very narrow context, and as a debug function at that. It's not needed to interoperate except to be able to be pasted into something and viewed. CSV works fine since I already know all of the data going into each cell and none of it will have commas. It can't.
So yeah, if i was doing a more general CSV export I'd definitely take your points. I've typically avoided CSV in favor of formats that allow for robust escaping/data delimiting, but sometimes we're stuck with what we have, rather than what we want =)
When I was growin' up, I was the smartest kid I knew. Maybe that was just because I didn't know that many kids. All I know is now I feel the opposite.