antbbn

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