MobileRead Forums - View Single Post

Noughty · 10-15-2011, 12:32 PM

I tried many combinations with only simple columns, with complicates ones. The result is always unusable since the first category isn't in quotes. I always get results like this:

Code:

Author,Author2,"title"

or

Code:

epub,pdf,txt,"title","Author,Author2"

while it should be

Code:

"epub,pdf,txt","title","Author,Author2"

So splitting to columns is impossible. The best result I get using " as a separator but sometimes " can be in fields and it messes it up too, just not as much.

There are no settings for creating csv files so I didn't mess it up. What could cause this?

Because of this I created unnecessary complicated columns in calibre (so I could export one already modified column without needing to split into columns) which increases workload for calibre a lot.

10-15-2011, 12:32 PM	#1
Noughty Addict Posts: 352 Karma: 103850 Join Date: Apr 2011 Device: Kindle NT	a bug with csv catalog (solution found) I tried many combinations with only simple columns, with complicates ones. The result is always unusable since the first category isn't in quotes. I always get results like this: Code: Author,Author2,"title" or Code: epub,pdf,txt,"title","Author,Author2" while it should be Code: "epub,pdf,txt","title","Author,Author2" So splitting to columns is impossible. The best result I get using " as a separator but sometimes " can be in fields and it messes it up too, just not as much. There are no settings for creating csv files so I didn't mess it up. What could cause this? Because of this I created unnecessary complicated columns in calibre (so I could export one already modified column without needing to split into columns) which increases workload for calibre a lot. Last edited by Noughty; 10-16-2011 at 10:28 AM.