Kovidgoyal,
Just updated to 8.0.34.
I chose export fields: Author-sort; Title; Publisher; ISBN. (Tried also the no-sort field)
Author-sort comes out first in the CSV,
but without quotes (" 's).
This field containes many comma's :-(
Other 3 fields
are in quotes.
I use MS-Excel 2002/2003 to import the CSV , to split the fields to columns ("Data to columns") and save in XLS format.
I can specify any printable character, or a tab, in MS-Excel to look for as a delimiter.
So if I could tell Calibre to use a # or ^ or < or ... as delimiter, that would solve the problem.
But I suspect a (simple?!?) omission in Calibre, not putting the first field in quotes.
BTW the first record in the CSV, the header, has no quotes at all.
I have found no way in Excel to convert UTF8 to "normal(?)"
e.g "é" comes out for "é"
>>>>>>>>>>>>>>>>>>>>
Stop press
<<<<<<<<<<<<<<<
>>>>> SORRY <<<<<<<<< >>>>>>>>>SORRY<<<<<<<<
Just thought of pgm texteditor EditPad: Has Unicode (and more) conversions.
Tried it while making this message.
Turns out: CSV of Calibre
HAS quotes around first fields of records
Apparently (stupid) MS-Excel strips those first pair of quotes (why)?!?!
Making it impossible to correctly divide the fields of the records further into cells.
[And: Editpad interprets UTF-8 correctly.]
So - for other readers with MS-Excel - summary:
Calibre export to CSV
("Create catalog ...")
Open CSV in Teksteditor.
Select All in texteditor;
Copy.
Open empty Excel-sheet; First cell;
Paste.
Then "
Text to columns" with " (quote) as delimiter.
[remove columns with , (comma) in them]
See screenshots to clarify my text.
Kovidgoyal, sorry long message, first part WRONG.
I let it in to show you how wrong users can be. Shame on us.
GREAT program, me new user, will be donating, soon as I finish trying out !
btw: delimiter of choice in CSV export still a wish
Thanks