Search Results

Rudi is right, i missed the conversion and header part, having hardcoded date value for the first field.

Please see correction :

BEGIN {
FS=","
OFS=";"
print...

Try this, save it as into file small.awk

BEGIN {
FS=","
OFS=";"
}
{
$1=strftime("%Y-%m-%d %H:%M:%S")
$2=86400
print $1,$2,$7,$3,$4,$5,$6,$NF
}


Run as :
awk -f small.awk test1 >...