topic AWK confusion in Operating System - Linux

AWK confusion

Patrick Wallek — Thu, 29 Mar 2007 11:38:53 GMT

I am trying to do some mass conversions of epoch time, to m/d/y hh:mm:ss formatted time. I have acquired an awk script from the internet that converts epoch time (epoch_time.awk is attached to this thread).

The script works well when I run it from the command line and pass the epoch time string.

# ./epoch_time.awk 1168097143
20070106152543

My problem is that this is not working when I am trying to use it from within a for loop or while loop. Such as:

# for i in $(cat myfile)
do
./epoch_time.awk ${i}
done
19700101000000
19700101000000
19700101000000
19700101000000
19700101000000
19700101000000

# head myfile
"1017942629"
"1018292324"
"1023462896"
"1023463449"
"1023469166"

It makes no difference to epoch_time.awk if the values have quotes around them or not.

This may be a case of not being able to see the forest for the trees. But I am confused and can't see where the problem may lie.

Any help is appreciated.

Re: AWK confusion

Patrick Wallek — Thu, 29 Mar 2007 11:41:24 GMT

Hmmm....Let's try attaching that file again.....

epoch_time.awk hopefully attached this time.

Re: AWK confusion

Duncan Edmonstone — Thu, 29 Mar 2007 11:49:55 GMT

Patrick,

its the double quotes - this works

for i in $(cat myfile | cut -d\" -f 2)
do
./epoch_time.awk ${i}
done

HTH

Duncan

Re: AWK confusion

Peter Nikitka — Thu, 29 Mar 2007 11:49:56 GMT

Hi,

of course is matters, whether your values in the file are quoted or not. Try

for i in $(do
eval ./epoch_time.awk ${i}
done

as a shortcut to eliminate the quotes.

mfG Peter

Re: AWK confusion

Hein van den Heuvel — Thu, 29 Mar 2007 11:53:31 GMT

It's the quotes. Strip them!

fwiw... I don't care for any scripts with hardcoded day tables. Yuck.

Cheers,
Hein.

Re: AWK confusion

Patrick Wallek — Thu, 29 Mar 2007 12:00:01 GMT

Well %$%#$%@$#%$#%!!!!!!!

I thought I tried stripping the quotes from the values in 'myfile'. Apparently not.

I guess what was throwing me off was that I had tried running the epoch_time.awk from the command line with the value quoted and it returned the correct value.

Live and learn.......

Thanks for pointing out what should've been fairly obvious.

Re: AWK confusion

A. Clay Stephenson — Thu, 29 Mar 2007 12:00:23 GMT

... and Patrick, why in the Wide World of Sports would you call an awk script for what is a one-liner in Perl using time() and localtime() or gmtime().

Re: AWK confusion

Patrick Wallek — Thu, 29 Mar 2007 12:01:57 GMT

Because I haven't found / taken / made the "time" to learn much Perl yet.

Re: AWK confusion

Hein van den Heuvel — Thu, 29 Mar 2007 12:11:04 GMT

Patrick..

On the live and learn...

May I finish that sentence with 'perl'

:-) :-)

You'll be in Vegas right?
We'll have a beer and i'll get you going on Perl :-)

perl -ne 'chomp;s/"//g;@t=localtime($_); printf ("%4d%02d%02d%02d%02d%02d\n", $t[5]+1900, $t[4]+1, $t[3], $t[2], $t[1], $t[0])' myfile

Re: AWK confusion

James R. Ferguson — Thu, 29 Mar 2007 12:59:13 GMT

Hi Patrick:

A bit late I am, but even shorter with Perl:

# perl -MPOSIX -ne 'print strftime("%Y%m%d%H%M%S\n",localtime($_))' file

The nice part is that the directives to 'strftime' are as you find them in the manpages.

Regards!

...JRF...

Re: AWK confusion

Patrick Wallek — Thu, 29 Mar 2007 13:10:18 GMT

Hein / JRF,

Thanks for the PERL snippets. Those will come in handy.

I would say there's about a 90% chance that I will be in Las Vegas, although I don't know for sure yet.