Guest User

Untitled

a guest
Oct 15th, 2015
236
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # Separate responses with new lines, delete empty lines and save into c2.txt:
  2. cat Contributors.txt | sed 's/{\"response\"/\n{\"response\"/g' | sed '/^$/d' > c2.txt
  3.  
  4. # generate CSV from JSON (asd.py: http://pastebin.com/MmVXisbU )
  5. # c2.csv is the full list
  6. cat c2.txt | ./asd.py > c2.csv
  7.  
  8. # delete the "$" character, select lines where display_amount > 150 (tablet); save c3.csv
  9. cat c2.csv | tr -d '$' | awk -F '\t' '$3 > 150 { print  $0 }' > c3.csv
  10.  
  11. # reverse the lines (maybe fix header by hand :-) )
  12. tac c3.csv > c4.csv
RAW Paste Data