diff options
| author | Zach DeCook <zach.decook@bettercarpeople.com> | 2022-10-17 11:57:51 -0400 |
|---|---|---|
| committer | Zach DeCook <zach.decook@bettercarpeople.com> | 2022-10-17 11:57:51 -0400 |
| commit | bef368a6363dadb025515a6a6d989d6cb7a3574f (patch) | |
| tree | f6d0e5b0bf373690ee8e3355406bac74cbbfbf1b /.local/bin/csv2sql.sh | |
| download | dotfiles-bef368a6363dadb025515a6a6d989d6cb7a3574f.tar.gz | |
work: initial commit
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' |