duckdb --json -c "SELECT CONCAT(column0, ' /', GROUP_CONCAT(column1, '/'), '/') as jisho FROM './import.csv' WHERE LENGTH(column0)+2 > LENGTH(column1) GROUP BY column0;" | jq -r ".[].jisho" > SKK-JISYO.delite
あれ
2024/9/25 0:39:00
duckdb --json -c "SELECT CONCAT(column0, ' /', GROUP_CONCAT(column1, '/'), '/') as jisho FROM './import.csv' WHERE LENGTH(column0)+2 > LENGTH(column1) GROUP BY column0;" | jq -r ".[].jisho" > SKK-JISYO.delite