doit.fish

csvjson IAN\'S\ Scavenger\ hunt\ data\ merge\ -\ August\ 10\ update.csv > data.json

echo -n "Converting to json - "
node index.js > br.json

echo -n "Delete data.json"

echo -n "Converting to CSV - "
json2csv -i br.json > yay.csv

echo -n "Converting to mac encoding - "
recode UTF-8..macintosh yay.csv

echo -n "Deleting temp files - "
rm br.json data.json

echo "done."

index.js

var fs = require('fs');
var obj = JSON.parse(fs.readFileSync('data.json', 'utf8'));

function pad(n, width, z) {
	z = z || '0';
	n = n + '';
	return n.length >= width ? n : new Array(width - n.length + 1).join(z) + n;
}

console.log("hi")


obj.forEach(element => {
	// console.log(element.clue)
	// console.log(element)
	for (prop in element) {
		// console.log(prop)

		if (element[prop]) {
			if (prop == "index") {
				let num = Number(element[prop])
				// element[prop] = pad(element[prop])
				// console.log(pad(num, 2))
				// console.log("hi")
				element[prop] = pad(num, 2)
			}
			else {
				element[prop] = element[prop].split("\n").join("<br>")
			}

			// element[prop].split("\n").forEach(e => {
			// 	console.log(`YAY: ${e}`)
			// })

		}
	}

	// element.clue.join("<br>")
	// console.log(element.clue)

});

fs.writeFile("br.json", JSON.stringify(obj), function (err) {
	if (err) return console.log(err)
})
// console.log(JSON.stringify(obj))