Shell Programming and Scripting

Hostname | Query: 0 | Release: 0 | files: 2 | Files_examined: 2 | SET timestamp=1396778638; | select * from test

Hostname | 0 | 0 | 2 | 2 | 04/06/2014|03:03:58 | select * from test

 
 sed -e 's/Query://g' -e 's/Release://g' -e 's/files://g' -e s'/Files_examined://g' -s s'/SET timestamp=//g'

 date -d @1396778638 "+%m/%d/%Y|%T"

 
04/06/2014|03:03:58

#!/bin/ksh
IAm=${0##*/}
tmpfile="$IAm.$$"
trap 'rm -f "$tmpfile"' EXIT
awk -F '( SET timestamp=)|(; )' -v tf="$tmpfile" '
{	system("date -d @" $2 " +\"%m/%d/%Y|%T\" > " tf)
	getline result < tf
	close(tf)
	$2 = result
	gsub(/[_[:alpha:]]*: /, "")
	print
}' file