View Single Post
Old 06-14-2019, 08:17 PM   #364
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 31,166
Karma: 60406498
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by coconuts View Post
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)
theducks is offline   Reply With Quote