Skip to content

Instantly share code, notes, and snippets.

@pilgrim2go
Created February 15, 2016 09:46
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pilgrim2go/3493bb0731d55f1d3add to your computer and use it in GitHub Desktop.
Save pilgrim2go/3493bb0731d55f1d3add to your computer and use it in GitHub Desktop.
CSV 2 JSON in Bash
#!/bin/bash
# CSV to JSON converter using BASH
# Usage ./csv2json input.csv > output.json
# http://blog.secaserver.com/2013/12/convert-csv-json-bash/
input=$1
[ -z $1 ] && echo "No CSV input file specified" && exit 1
[ ! -e $input ] && echo "Unable to locate $1" && exit 1
read first_line < $input
a=0
headings=`echo $first_line | awk -F, {'print NF'}`
lines=`cat $input | wc -l`
while [ $a -lt $headings ]
do
head_array[$a]=$(echo $first_line | awk -v x=$(($a + 1)) -F"," '{print $x}')
a=$(($a+1))
done
c=0
echo "{"
while [ $c -lt $lines ]
do
read each_line
if [ $c -ne 0 ]; then
d=0
echo -n "{"
while [ $d -lt $headings ]
do
each_element=$(echo $each_line | awk -v y=$(($d + 1)) -F"," '{print $y}')
if [ $d -ne $(($headings-1)) ]; then
echo -n ${head_array[$d]}":"$each_element","
else
echo -n ${head_array[$d]}":"$each_element
fi
d=$(($d+1))
done
if [ $c -eq $(($lines-1)) ]; then
echo "}"
else
echo "},"
fi
fi
c=$(($c+1))
done < $input
echo "}"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment