+ latin = (cell[0].get_text(" ", strip=True)).rstrip()
+ english = (cell[1].get_text(" ", strip=True)).rstrip()
+ notes = (cell[2].get_text(" ", strip=True)).rstrip()
+
+ c.execute("""INSERT INTO phrases
+ (id, latin, english, notes, length)
+ VALUES(?, ?, ?, ?, ?)""",
+ (i, latin, english, notes, len(latin)))
+ conn.commit()
+ i = i + 1