ateucher · August 29, 2015 14:15
diff --git a/gensub.sh b/gensub.sh
 gawk -F, '
 BEGIN { OFS = ",";
 print "id,name,date_time,val,val2,val3"}
 {
 $3=gensub(/(^[0-9]{2})([A-Z]{3})([0-9]{4}):([0-9]{2}:[0-9]{2}:[0-9]{2})$/,
 "\\3-\\2-\\1 \\4 PST","g",$3)
 print $0 
 }' testfile.csv
diff --git a/testfile.csv b/testfile.csv
	gawk -F, '
	BEGIN { OFS = ",";
	print "id,name,date_time,val,val2,val3"}
	{
	$3=gensub(/(^[0-9]{2})([A-Z]{3})([0-9]{4}):([0-9]{2}:[0-9]{2}:[0-9]{2})$/,
	"\\3-\\2-\\1 \\4 PST","g",$3)
	print $0
	}' testfile.csv