View gist:c270383330ef9dde68c9
My try in bash abusing cut(1) with grouping by time: | |
for i in $(curl whatever | cut -sd "," -f 1,5,6 | grep -v null | head ) | |
do | |
NAME=$(echo $i | cut -d '"' -f 4) | |
TIME=$(echo $i | cut -d '"' -f 8 | cut -d ' ' -f 1 | tr -d '-') | |
CC=$(echo $i | cut -d '"' -f 12) | |
echo $NAME,$CC > $TIME.csv | |
done |