Quote:
Originally Posted by jmurphy
In his defense, the screen-shot you included (that had all the tooltips) CLEARLY shows that identifiers should be single-quoted.
|
In your defense, clearly you are ignorant of CSV file-save options, and do not know how to view a CSV file in a Text Viewer to see the 'real' CSV data.
The double-quotes are for the CSV cells, not the data, as I stated. The double-quotes are inserted by Calc/Excel during the save-as file save option which I referenced. The ToolTips are about what you "see" in Calc/Excel.
Open a CSV file in a
Text Viewer to see what the CSV file really looks like without being manipulated by Calc/Excel.
From the .../calibre/plugins/job spy/resources/ example CSV file, as viewed by NotePad. Note the Identifier column. Example cell: ,"'zmyid':'0123456789'",
Calc automatically added the double-quotes per the Save-As > Edit Filter options as shown in the attached image.
I added the single quotes in Calc, as shown in the ToolTips.
Code:
"#bookid","added","title ","publisher ","pubdate","comments","tags","identifiers","series","#genre","#myyesno","#myserieslike","#mycomments","#mytaglike"
"25489","2019-01-01","Title1","DaltonST","1960-01-01","These are comments with many commas , and ,, and ,,, and here too ,.","Fiction:Science-Classic,Fiction:Science-Space Opera","'zmyid':'0123456789'","Kzin[1]","Fiction:Science","true","MySeries[1]","These are my comments.","Factual:Autobiography"
"26100","2019-01-01","Title2","DaltonST","1960-01-01","These are comments with no commas but with "double-quotes".","Factual:Biography","'zmyid':'0123456789'","Kzin[0]","Factual:Biography","false","MySeries[2]","These are also my comments","Fiction:Romance"
All of the above has been previously described over the years. Nothing new here.
DaltonST