View Single Post
Old 10-13-2011, 10:13 AM   #4
Noughty
Addict
Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.
 
Posts: 352
Karma: 103850
Join Date: Apr 2011
Device: Kindle NT
I wanted to ask about the same, but I would like to separate columns. I know how to do it only with copying data to txt file and opening it in excel and then separating columns.
I tried using comma and quotes as separator but the problem is with first column.
If I choose " I get first column with a comma at the end which I clearly don't need.
If I choose comma I get a complete mess since the first values aren't in quotes and they do have a few values in them separated by comma so they all end up in separate columns.

So how to make csv file which is easily spread into neat columns? Is it possible to force it to add quotes to ALL columns including first one?

Or maybe it possible to choose columns order. Now it adds it alphabetically which makes complete mess again if you choose tags, title, author, series, formats. You end up with title at the end etc. I could choose first the column which wouldn't cause any problems being without quotes.

As a final resort I am thinking of making a bunch of new columns to add quotes to all values but I already have way too many columns... And this looks a little extreme.

SOLVED: I managed to make a column which gives the spreadsheet if I create catalog (csv) from only that one column. Took me awhile to create the template but it works great since I have one neat column in result already correctly formated and can print it, copy it in word or any other program etc.

Last edited by Noughty; 10-14-2011 at 03:54 AM. Reason: solved
Noughty is offline   Reply With Quote