Quote:
Originally Posted by coconuts
Up until this point I have been using fictfact to track what books I have read. They have closed down so I have a csv file with all the information from that site. Unfortunately they list the first and last name of the author in separate columns. I can successfully import the csv file with just the last name but can not figure out how to get the first name without retyping 1500 entries. I tried adding a column called comments with the first name then having it as #3 (#1 title, #2 author last name, #3 comments, #4 series title) but even in the preview it came in fourth and did not show up at all when imported to Calibre. Any suggestions?
|
Do you have a spreadsheet program? Use that to create a new column with LN concatenated with FN (IMHO Fn<sp here> Ln is easy to construct)
No spreadsheet?
Libre Office is Free and there is versions for most common OS)