Re: awk 'system("date +%s -d ")'

On 2/24/2008 4:36 PM, DanielC wrote:
>>>$ echo "[2008-02-24 21:07:08.149124] 6451642 196612 547 0 6839170" |
awk 
>>>'{print gensub(/\[(....)-(..)-(..) (..):(..):(..).*/,"\\1 \\2 \\3 \\4
\\5 
>>>\\6","")}'
>>>2008 02 24 21 07 08
>>
> 
> This is great! I don't know gensub() can do that.
> 
> 
>>>However, # awk -F "[].[]+" 'system("date +%s -d " $2)' /tmp/logfile 
>>>doesn't.
>>>
>>
>>Doesn't what? What do you want the output to be?
> 
> 
> I want # awk -F "[].[]+" 'system("date +%s -d " $2)' /tmp/logfile 
output 
> the timestamp like $ awk 'BEGIN {system("date +%s -d " "\"2008-02-24 
> 09:14:03\"")}' does. However it doesn't.
> 
> # echo "[2008-02-24 21:07:08.149124] 6451642 196612 547 0 6839170" | awk
-F 
> "[].[]+" 'system("date +%s -d ") $2'
> date: option requires an argument -- d
> Try `date --help' for more information.
> [2008-02-24 21:07:08.149124] 6451642 196612 547 0 6839170

This seems to be what you're asking for:

$ echo "[2008-02-24 21:07:08.149124] 6451642 196612 547 0 6839170" |
awk -F "[].[]+" 'system("date +%s -d \"" $2 "\"")'
1203908828

but I'm sure there's a better way to do whatever it is you're trying to do
just
using awk instead of jumping back and forth between awk and shell
commands. If
you can show us some sample input and expected out, I expect we could
help.

	Ed.