From ed45f26f1c87ac9a27436288b67af66a8abb20ed Mon Sep 17 00:00:00 2001
From: Zach DeCook <zach.decook@bettercarpeople.com>
Date: Tue, 3 Sep 2024 11:22:56 -0400
Subject: csv2*: minor changes

---
 .local/bin/csv2sql.sh | 4 ++++
 1 file changed, 4 insertions(+)

(limited to '.local/bin/csv2sql.sh')

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' |
-- 
cgit 1.4.1