personal dotfiles: my Hyprland config
Diffstat (limited to '.local/bin/csv2sql.sh')
| -rwxr-xr-x | .local/bin/csv2sql.sh | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/.local/bin/csv2sql.sh b/.local/bin/csv2sql.sh new file mode 100755 index 0000000..7f4a8d5 --- /dev/null +++ b/.local/bin/csv2sql.sh @@ -0,0 +1,13 @@ +#!/bin/sh +# Quote everything, +tr , "\t" | +sed 's/\t\([^"\t]\+\)/\t"\1"/g' | +sed 's/\([^"\t]\+\)\t/"\1"\t/g' | +# replace empty with null, +sed 's/\t\t/\tnull\t/g' | +sed 's/\t\t/\tnull\t/g' | +sed 's/\t$/\tnull/g' | +sed 's/^\t/null\t/g' | +tr "\t" , | +# and add parens around each line +sed 's/^/(/g' | sed 's/$/),/g' |