[SOLVED] How to match different records based on Same Field values using awk

Abdelrahman.fathy · 11-10-2015, 10:30 AM

Grail if you are talking about strftime and UTC flag ,I cannot confirm if it did work. I will check it and let you know

Abdelrahman.fathy · 11-11-2015, 02:30 AM

grail;
i've used this function and it's doing the job

Code:

function ConvAST_To_GMT(timestamp)
{
	c="date -ud "timestamp;
	out=c|getline;
	close(c);
	return $0;
	
}

and i call it using IT="@" InFields[9] this as argument
where InFields[9] is the timestamp output from mktime

Another question is i have time like hh:mm
i want to concatenate 00 as ss
so that i can send the output to mktime
i tried this
DenyTimePart=OutDenials[11] "" ":" "00";
and so many other variation but none of them did the job

grail · 11-11-2015, 03:39 AM

So here is the simple line I used to convert to UTC:

Code:

echo 'OUT IamFeatureName 2013.11 9 IamUserName IamHostName "" 20 20 0 1cc 1cc 2af0 "" "" "" 07/15 13:27:12' | awk '{dspec = "2015"FS$17FS$18; NF=16;print $0,strftime("a %b %e %H:%M:%S %Z %Y",mktime(gensub(/[:/]/," ","g",dspec)),1),dspec}'

As for appending '00', I would need more information on why you think it does not work? I do see a needless pair of quotes after the array, but would not see these causing any issue.

Abdelrahman.fathy · 11-11-2015, 03:44 AM

thanks for the response but these needless pair of qoutes are needed for forcing awk to convert number to string so i can right pad with two zeros in place of seconds ofcousrse with space between them
for example if i have 10:15 as OutDenials[11]

i need output like 10 15 00

Abdelrahman.fathy · 11-11-2015, 03:52 AM

also your line that you posted produces an error:
awk: fatal: 3 is invalid as number of arguments for strftime
maybe it's the awk version(i've GNU Awk 3.1.5) or something else

grail · 11-11-2015, 05:02 AM

Well i see no reference to say it is a new feature to include the utc-flag, but maybe, my version is 4.1.3

As for the concatenation, I am not sure I follow, the below simple test seems to work just fine:

Code:

echo "10:57" | awk '{print $0":00"}'

No additional sets of quotes needed

Abdelrahman.fathy · 11-11-2015, 10:11 PM

grail,
I'm sorry to bother you too much but can you look at the output , i've exactly used your statment:

Code:

{print $0":00"}

:00Y Blah_check 1.0 trudy DellHd-77 "" 1 -18 1 07/15 13:27

I mean the keyword Deny in the start have been overwritten

Abdelrahman.fathy · 11-11-2015, 10:32 PM

Grail, it's ok i find my problem,
It's the difference between MSFT(Microsoft) and linux
i guess there was some non printable or some control character difference , so i used dos2unix and convert it and now your code is running fine.