Export as CSV problem : commas in article titles, lastname, firstname etc.
I want to export into a spreadsheet so that I can sort records by journal name and year. An alternative would be to produce some report directly from Zotero but I don't think that is possible. The commas that are in article titles and the author names lastname, firstname with semicolon separation, etc makes the data misaligned from the column headings.
Am I overlooking something obvious that will fix this. I'm using LibreOffice Calc.
The closest I can come to having data below column headings is to use a double quote (") as the separator. Is there a better idea? I need a count of articles by journal with a count of journal names.
Am I overlooking something obvious that will fix this. I'm using LibreOffice Calc.
The closest I can come to having data below column headings is to use a double quote (") as the separator. Is there a better idea? I need a count of articles by journal with a count of journal names.
https://forums.zotero.org/discussion/77225/to-extract-journals-names-from-the-library
It doesn't do counts by year though.
,
,;
and"
? Or are you parsing data inside individual columns?