View Single Post
Old 07-09-2019, 04:42 AM   #11
Tex2002ans
Wizard
Tex2002ans ought to be getting tired of karma fortunes by now.Tex2002ans ought to be getting tired of karma fortunes by now.Tex2002ans ought to be getting tired of karma fortunes by now.Tex2002ans ought to be getting tired of karma fortunes by now.Tex2002ans ought to be getting tired of karma fortunes by now.Tex2002ans ought to be getting tired of karma fortunes by now.Tex2002ans ought to be getting tired of karma fortunes by now.Tex2002ans ought to be getting tired of karma fortunes by now.Tex2002ans ought to be getting tired of karma fortunes by now.Tex2002ans ought to be getting tired of karma fortunes by now.Tex2002ans ought to be getting tired of karma fortunes by now.
 
Posts: 2,306
Karma: 13057279
Join Date: Jul 2012
Device: Kobo Forma, Nook
Quote:
Originally Posted by KevinH View Post
BTW, Calc like excel will parse most text files if delimited in some way (need not be commas and quotes) or if field aligned.
Yep, tab-delimited is usually my favorite. Commas are just too common, and make manually reading the file in a text editor a chore.

Whenever exporting CSVs into LibreOffice Calc, a nice window pops up giving you lots of import options.

Quote:
Originally Posted by elchamaco View Post
That csv export from reports is something like i was searching, but for the missing words. But playing with the editor of calibre i see it has an option to copy to clipboard all the words from spellcheck and paste them in an excel. This also works for me.
You can also use the Spellcheck Lists in non-standard ways. Like in this thread, I explained how to use it to find a list of "foreign-language" words:

https://www.mobileread.com/forums/sh...59#post3812859

and go marking them up with xml:lang.

I've also done something similar when trying to normalize a collection of various articles between American/British spellings. You could:
  1. Mark ebook as English (US).
  2. Export CSV of "misspelled words".
  3. Mark ebook as English (UK).
  4. Export CSV of "misspelled words".

Compare both CSVs together, look at differences, and you can see:
  • Words that appear in one list are almost all the differently spelled words.
    • color <-> colour
  • Words that appear in both lists are almost all the actual misspelled/foreign words.
    • forign" + "sofritos"

Last edited by Tex2002ans; 07-09-2019 at 05:19 AM.
Tex2002ans is offline   Reply With Quote