3 ms·
No mention of vi or Sqlite? While I'm no vi expert it's a great tool for working with big files when you want to browse around without grep. And Sqlite is simil
by paulryanrogers 7y ago
No mention of vi or Sqlite? While I'm no vi expert it's a great tool for working with big files when you want to browse around without grep. And Sqlite is similarly ubiquitous and capable of crunching large files.
- alecdibble 7y agovi 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!