nagpal/gist:5037724

Created February 26, 2013 11:09

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/nagpal/5037724.js"></script>
Save nagpal/5037724 to your computer and use it in GitHub Desktop.

Download ZIP

JSON to CSV - for importing in excel.

Raw

gistfile1.txt

cat filename.json | sed -e 's/{/\n/g' | sed -e 's/}//g' | sed -e 's/\"//g' | awk 'BEGIN {FS=","} {for (i=1; i<=NF; i++) printf("%s,",substr($i,index($i,":")+1)); printf("\n"); }' | sed -e 's/[,]*$//g' > filename.csv

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment