4 ms·
vi is an editor so it doesn't really solve my requirement of getting spreadsheet-like editing capabilities. SQlite is a good idea, I never thought of that. I wi
by alecdibble 7y ago
vi is an editor so it doesn't really solve my requirement of getting spreadsheet-like editing capabilities. SQlite is a good idea, I never thought of that. I will investigate that and add it to the article. Thanks!
- gav 7y agoSQLite 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/ https://sqlitebrowser.org/
- alecdibble 7y agoAmazing, I will definitely try this out. Thank you!