log-normalize.sh

#!/bin/bash

if ! [ $# -eq 1 ];
then
 echo "./log-normalize.sh <file>"
 exit
fi

file=$1
NAME=`echo "$file" | cut -d'.' -f1`

sed 's/ : Auth: /,Auth,/' $file|sed 's/: \[/,\[/'|sed 's/ (/,/'|sed 's/from client /from client,/'|sed 's/ port /,port,/' |sed 's/ cli /,cli,/'|sed 's/)//' > $NAME-normalize.csv

while read line; do
 a=`printf "%s" "$line"|awk -F',' '{print $1}'`
 unix=`date -d "$a" +"%s"`
 printf "%s,%s\n" "$unix" "$line" >> $NAME-normalize-2.csv
done < $NAME-normalize.csv