From 3db8fb5dac8135a91a57a4cc3c318500295858a3 Mon Sep 17 00:00:00 2001
From: Bdale Garbee <bdale@gag.com>
Date: Sat, 24 Oct 2015 20:41:33 -0600
Subject: [PATCH] quote all fields except quantity to avoid confusing
 LibreOffice Calc

---
 bin/fillpartscsv | 26 +++++++++++++-------------
 1 file changed, 13 insertions(+), 13 deletions(-)

diff --git a/bin/fillpartscsv b/bin/fillpartscsv
index e03e68c..68c6a16 100644
--- a/bin/fillpartscsv
+++ b/bin/fillpartscsv
@@ -10,28 +10,28 @@ BEGIN {
 		partcount++
 		parts[$1, $2, $3] = $0
 	}
+	FS = ","
 }
 
 {
-	FS = ","
 	split(parts[$1,$2,$3],field,"\t")
 
-	printf "%s,%s,%s", $1, $2, $3
+	printf "\"%s\",\"%s\",\"%s\"", $1, $2, $3
 
-	if ( $4 == "unknown") printf ",%s", field[4]
-	else printf ",%s", $4
+	if ( $4 == "unknown") printf ",\"%s\"", field[4]
+	else printf ",\"%s\"", $4
 
-	if ( $5 == "unknown") printf ",%s", field[5]
-	else printf ",%s", $5
+	if ( $5 == "unknown") printf ",\"%s\"", field[5]
+	else printf ",\"%s\"", $5
 
-	if ( $6 == "unknown") printf ",%s", field[6]
-	else printf ",%s", $6
+	if ( $6 == "unknown") printf ",\"%s\"", field[6]
+	else printf ",\"%s\"", $6
 
-	if ( $7 == "unknown") printf ",%s", field[7]
-	else printf ",%s", $7
+	if ( $7 == "unknown") printf ",\"%s\"", field[7]
+	else printf ",\"%s\"", $7
 
-	if ( $8 == "unknown") printf ",%s", field[8]
-	else printf ",%s", $8
+	if ( $8 == "unknown") printf ",\"%s\"", field[8]
+	else printf ",\"%s\"", $8
 
-	printf ",%s,%s\n", $9, $10
+	printf ",%s,\"%s\"\n", $9, $10
 }
-- 
2.47.2