diff options
Diffstat (limited to '.local/bin/csv2sql.sh')
| -rwxr-xr-x | .local/bin/csv2sql.sh | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/.local/bin/csv2sql.sh b/.local/bin/csv2sql.sh index 7f4a8d5..f080f36 100755 --- a/.local/bin/csv2sql.sh +++ b/.local/bin/csv2sql.sh @@ -3,6 +3,10 @@ tr , "\t" | sed 's/\t\([^"\t]\+\)/\t"\1"/g' | sed 's/\([^"\t]\+\)\t/"\1"\t/g' | +# Switch CSV " escaping to SQL escaping +sed 's/""/\\"/g' | +#sed 's/\\r/\\\\r/g' | +#sed 's/\\n/\\\\n/g' | # replace empty with null, sed 's/\t\t/\tnull\t/g' | sed 's/\t\t/\tnull\t/g' | |