Extract general information from Wahoo workout data(CSV).

wahootsv.awk

#usage 
# find %Dropbox%/Apps/Wahoo | grep csv$ | sort | awk -f wahoo2csv.awk
# Date, TotalDistance, Time, AverageSpeed

BEGIN {
	FS=","
	general_info_flg=0
	distance=0
}

$1 == "Year" {
	printf("\"%04d/%02d/%02d %02d:%02d\",",$2,$4,$6,$8,$10)
}

general_info_flg {
	distance+=$5/1000
	printf("\"%.3f\",\"%.3f\",\"%.3f\"\n", distance, $3/60, $7*3600/1000)
	general_info_flg=0
}

/^workout,/{
	general_info_flg=1
}