Shell Programming and Scripting

1442814667.478     76 4.3.2.1 TCP_MISS/200 31845 GET http://pippo.com/inde.html - DIRECT/1.2.3.4 text/css

1442814667.478,76,4.3.2.1,TCP_MISS/200,31845,GET, http://pippo.com,-, DIRECT/1.2.3.4,text/css

[root@site a]# cat log.log |while read a b c d e f g h i l;
do
PIPPO=`echo $g |cut -f1 -d"/"`;
PLUTO=`echo $a |cut -f1 -d"."`;
echo "$PLUTO,$b,$c,$d,$e,$f,$PIPPO,$h,$i,$l" >>sasha.csv
done
[root@site a]# -

#!/bin/ksh
awk -v OFS=, '
{	sub("[.][^.]*$", "", $1)
	sub("/[^/]*$", "", $7)
	$1=$1
}
1' log.log >>sasha.csv

while read a b c d e f g h i j
do	printf '%s,%s,%s,%s,%s,%s,%s,%s,%s,%s\n' "${a%.*}" "$b" "$c" "$d" "$e" \
	    "$f" "${g%/*}" "$h" "$i" "$j"
done < log.log >> sasha.csv

1442814667,76,4.3.2.1,TCP_MISS/200,31845,GET,http://pippo.com,-,DIRECT/1.2.3.4,text/css