How about the ability to change the CSV delimiter?

[gjc999]

I know it's called a comma separated value file for a reason, but it would be helpful to be able to change the delimiter to something else on an export. I have a lot of location data that has a comma in the value, and the export is being parsed funny by open-office. If there was a way to select "|" or "\" or something like that, it would be useful on occasion. Either have it in the export dialog as an option, or maybe have another setting in the preferences dialog.

[nick]

Which piece of data ?

The fields are all output in quotes, so they shouldn't be getting confused by commas in values. Is it just open office? Does QuickLook deal with it correctly (just select it in the finder and quicklook it) ?

I can look at adding an option but it shouldn't be happening.

[gjc999]

My data in the location column is almost always something like "Town, State", like "Boston, MA". I just opened an export in TextEdit and now that I look at it it looks correct:

Code: Select all

"32.00", "2008-06-01 09:34:00 -0400", "Webster, MA", "31.00", "0.00", "Webster Lake", "74.03", "1965", "Training", "Good"

At first it seemed the OpenOffice CSV import wizard is completely ignoring the " " that surrounds the field. After further investigation however it looks to be the whitespace between the comma and the quotes. This line is consumed by OpenOffice just fine:

Code: Select all

"32.00","2008-06-01 09:34:00 -0400","Webster, MA","31.00","0.00","Webster Lake","74.03","1965","Training","Good"

So, maybe forget the selectable delimiter and remove the whitespace characters?

[gjc999]

QuickLook displayed the file perfectly by the way...

[nick]

Wow, OpenOffice being picky

Sure, I can remove the whitespace no problem.

[nick]

Sorted for the next patch.