Convert a CSV file to HTML using SQLite.
Small wrapper around sqlite3 to convert a CSV file (double quoted and comma seperated) to HTML with built-in search function.
csv2html <csv-file> [generated-db-file] [tablename] [> myhtmloutput.html]
~/bin/csv2html.sh scan-2024-06-21.csv scan-2024-06-21.db scanresults > scan-2024-06-21.html
This will convert scan-2024-06-21.csv to scan-2024-06-21.html file, and leave a sqlite3 scan-2024-06-21.db file, containing a single table named "scanresults".
- Large HTML files will crash your browser.
- The intermediate Sqlite DB file will probably be the most useful, if you know a little SQL ;-)
- USE WITH CAUTION, THIS IS NOT THOUROUGHLY TESTED.