The default for the query attachment is to just have a blank space between the columns. One blank space. Just because you use the ".csv" file extension doesn't change that. If you don't use the separator, and just save as csv, what you get is one column, with spaces between the "columns" that you should have.
For simple-CSV, you should separate with a comma. That, after all, is what CSV is supposed to mean. However, CSV files usually have quotation marks around the data, as well as commas, because a comma by itself is too error-prone. The separator, however, is limited to one character, so you can't do that.
On the other hand, if you separate with a tab-character, or with a vertical pipe, Excel and most other programs can use those to easily break columns back up again. You'll want to list the file as either txt or xls in that case, not csv. Both are pretty standard, but tabs often make the file more human-readable than pipes, if that matters.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon