Skip to content

Instantly share code, notes, and snippets.

@nakaly

nakaly/jlpt_words.md

Created July 30, 2016 07:53
Show Gist options
  • Star 11 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save nakaly/c2c855766ce1661e11396b09760b9598 to your computer and use it in GitHub Desktop.
Save nakaly/c2c855766ce1661e11396b09760b9598 to your computer and use it in GitHub Desktop.
Download ZIP
JLPT Words N1 - N5
@nakaly
Copy link
Author

nakaly commented Jul 30, 2016

  1. こちらのサイトからsqliteで読み込める単語のリストをダウンロード
  2. 必要な部分だけcsvファイルに出力
 ❯ sqlite3 n1-vocab-kanji-eng.anki                                                                         [16:47:28]
SQLite version 3.8.10.2 2015-05-20 18:17:19
Enter ".help" for usage hints.
sqlite> .mode csv
sqlite> .output n1_sqlite.csv
sqlite> select question  from cards;
sqlite>
  1. 不必要な部分を削除
sed -e 's/^/1,/g' n1_sqlite.csv | sed -e 's/\"<span.*\">//g' | sed -e 's/<\/span>\"//g' | sed -e 's/\//\'$'\n1,/g' > n1_words.csv

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment