log2csv.sh (1180B)
1 #!/bin/sh 2 LOG_FILE=$1 3 shift 1 4 5 TRANSPOSE=$(dirname $0)/transpose.sh 6 7 CSV_FILE="$LOG_FILE.csv" 8 CSV_T_FILE="$CSV_FILE.T" 9 10 echo "\"Iteration\" $(cat $LOG_FILE | grep mess | awk '{print NR}' | $TRANSPOSE)" > $CSV_T_FILE 11 echo "\"Messages\" $(cat $LOG_FILE | grep mess | awk '{print $1}' | $TRANSPOSE)" >> $CSV_T_FILE 12 echo "\"Receipients\" $(cat $LOG_FILE | grep mess | awk '{print $4}' | $TRANSPOSE)" >> $CSV_T_FILE 13 echo "\"Duration_(in_ms)\" $(cat $LOG_FILE | grep mess | awk '{print $10}' | rev | cut -c3- | rev | $TRANSPOSE)" >> $CSV_T_FILE 14 echo "\"Minimum_latency_(in_ms)\" $(cat $LOG_FILE | grep rtt | awk '{print $4}' | tr '/' ' ' | awk '{print $1}' | $TRANSPOSE)" >> $CSV_T_FILE 15 echo "\"Average_latency_(in_ms)\" $(cat $LOG_FILE | grep rtt | awk '{print $4}' | tr '/' ' ' | awk '{print $2}' | $TRANSPOSE)" >> $CSV_T_FILE 16 echo "\"Maximum_latency_(in_ms)\" $(cat $LOG_FILE | grep rtt | awk '{print $4}' | tr '/' ' ' | awk '{print $3}' | $TRANSPOSE)" >> $CSV_T_FILE 17 echo "\"Variance_of_latency_(in_ms)\" $(cat $LOG_FILE | grep rtt | awk '{print $4}' | tr '/' ' ' | awk '{print $4}' | $TRANSPOSE)" >> $CSV_T_FILE 18 19 cat $CSV_T_FILE | $TRANSPOSE | tr _ ' ' > $CSV_FILE 20 rm $CSV_T_FILE 21