Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # Separate responses with new lines, delete empty lines and save into c2.txt:
- cat Contributors.txt | sed 's/{\"response\"/\n{\"response\"/g' | sed '/^$/d' > c2.txt
- # generate CSV from JSON (asd.py: http://pastebin.com/MmVXisbU )
- # c2.csv is the full list
- cat c2.txt | ./asd.py > c2.csv
- # delete the "$" character, select lines where display_amount > 150 (tablet); save c3.csv
- cat c2.csv | tr -d '$' | awk -F '\t' '$3 > 150 { print $0 }' > c3.csv
- # reverse the lines (maybe fix header by hand :-) )
- tac c3.csv > c4.csv
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement