Epwing2Anki - Tool For Automatically Generating Anki Vocabulary Cards

rich_f Wrote:...Also, a general question-- cb, I seem to recall one of your programs could take a word list and compare it against another file. Is there one that does that, or am I just remembering something wrong? What I'm looking for is something where I can export my deck into a tsv/txt file, and compare it with a word list before wasting a lot of time finding out I'm adding words I've already added.

It would be a lot faster than searching word by word, especially if the word list is ~2-4k long. (I'm building one of those right now for N1, based on a few vocab builder books, but I don't want to waste time learning words I already know!)

Rich_f, here is a simple, though not elegant, solution in the meantime:

- create a column in openoffice calc of all the words you've learned (column A)
- then paste the list you want to filter into column B
- next, paste this into the first cell in column C =MATCH($B1;$A$1:$A$3018;0) <--replacing 3018 with the final row number of your list in column A. Be sure to use the '$'s exactly as shown, they ensure that the next step will work as intended
- copy and paste the content of C1 (or "drag" it) into the remaining cells in column C with an entry beside them in B
- You should now have a list of numbers and '#NA's.
- select column B and C and 'data>sort' them based on column C (ascending). This should place all of the #NA words on top. These are the ones you want as they have no matches in column A. The numbers refer to the matching entries in the range you selected (not necessarily to the row number if your list doesn't begin in row 1.)
- copy and paste these words into a text document or delete the all other cells and save as a text file or csv (I'm not sure what format Epwing2anki needs).
hth

EDIT: In case you have a reason to keep your unknown list in a certain order (besides alphabetical/a-ka-sa-ta), create a "key" column in D by typing '1' into D1 and '2' into D2, then selecting both and dragging the corner of D2 downward until you reach the last row used by column B. Now, when you sort the results as in the second to last step above, select columns B,C AND D. Then, after deleting the matches in column B, re-sort columns B and D based on D (ascending).