|
|
|
|
|
by gav
2425 days ago
|
|
SQLite does a great job of importing CSV, and then you're able to use something like "DB Browser for SQLite"[1] to browse the data. I use something like this to fix up column names and import: sed -i '' -e '1 s/ \/ /_/g; 1 s/[() ]/_/g' $csv_file
sqlite3 $db_file <<SQL
.mode csv
.import $csv_file $table_name
SQL
[1] https://sqlitebrowser.org/ |
|