topic Re: Awk help in Operating System - HP-UX

Awk help

tom quach_1 — Wed, 16 Mar 2011 04:42:30 GMT

Hi All,
sql statement returned 2 columns and i like to get the result of a second column " RUNNING" using awk '{print $2}'

but because of space between the words. the result was not correct.

Please give some suggestions on how to use "awk" or "cut" to get the result which is the
"RUNNING"

Thanks in advance.

Workflow Deferred Agent Listener RUNNING
Workflow Deferred Notification Agent Listener RUNNING
Workflow Error Agent Listener RUNNING
Workflow Inbound JMS Agent Listener RUNNING
Workflow Inbound Notifications Agent Listener RUNNING
Workflow Java Deferred Agent Listener RUNNING
Workflow Java Error Agent Listener RUNNING

Re: Awk help

Dennis Handly — Wed, 16 Mar 2011 07:06:15 GMT

>but because of space between the words. the result was not correct.

You are going to have to provide more details of how the fields are defined. Unless you always want the last column?

You can use awk to print the last column, $NF. And work backward, $(NF-1).

Otherwise you may have to use advanced AI technology to determine where your fields begin and end.

Re: Awk help

Jose Mosquera — Wed, 16 Mar 2011 07:17:49 GMT

Hi,

I've noticed that in all lines always appear "Agent Listener " before "RUNNING", so you can use it as field limiter. eg:
#cat sample.txt
Workflow Deferred Agent Listener RUNNING
Workflow Deferred Notification Agent Listener RUNNING
Workflow Error Agent Listener RUNNING
Workflow Inbound JMS Agent Listener RUNNING
Workflow Inbound Notifications Agent Listener RUNNING
Workflow Java Deferred Agent Listener RUNNING
Workflow Java Error Agent Listener RUNNING

#cat sample.txt |awk -F"Agent Listener " '{ print $2 }'
RUNNING
RUNNING
RUNNING
RUNNING
RUNNING
RUNNING
RUNNING

I hope it will be useful.

Rgds.

Re: Awk help

Bill Hassell — Wed, 16 Mar 2011 10:29:25 GMT

If you simply want the last item on each line:

awk '{print $NF}' /tmp/mysql.out

Re: Awk help

Raj D. — Wed, 16 Mar 2011 10:52:29 GMT

Tom,
You can try this,

# awk '{for (i=0;i<=NF;++i) if ($i ~ "RUNNING") print $0 }' file

It will print all the line contains RUNNING .

Cheers,
Raj.

Re: Awk help

tom quach_1 — Wed, 16 Mar 2011 15:37:38 GMT

Thank you all for your helps.
Regards,