topic Re: Awk - using one field separator, then another? in Operating System - HP-UX

Awk - using one field separator, then another?

Tony Walker — Thu, 18 Sep 2003 08:47:56 GMT

Hi guys,

Here's one thats been bugging me for a while. Basically, I want to pull out the current load average from uptime ie :
10:46am up 55 days, 14:06, 159 users, load average: 3.34, 3.28, 3.39

Theory goes, use and FS of ":" and get the 4th field, then use an FS of "," and get the first thus ending up with 3.34. I'm sure there are better ways but I've come across a similar problem before and want to know whether this is possible in awk?

As always, help greatly appreciated.

Cheers,

Tony

Re: Awk - using one field separator, then another?

Mark Grant — Thu, 18 Sep 2003 09:07:12 GMT

This depends a little bit on how you want the information returned toyou but how about

expr "`uptime`" : ".*load average: $.*$" and pipe the
output into "cut" or "awk" or whatever.

Re: Awk - using one field separator, then another?

Jean-Luc Oudart — Thu, 18 Sep 2003 09:28:31 GMT

Tony

1) you can replace "," with spaces either with sed or tr before you pipe results into awk

2) you can use the split function in awk
split(s,a,fs) fs = field separator

Rgds,
Jean-Luc

Re: Awk - using one field separator, then another?

Tony Walker — Thu, 18 Sep 2003 09:38:32 GMT

Jean-luc - I should have awarded you 10points! Just tried the split function in awk and it works just how I want.

Thanks!

Tony

Re: Awk - using one field separator, then another?

Jean-Luc Oudart — Thu, 18 Sep 2003 09:45:57 GMT

Usually the "bunny" means that solution is provided and complete.

Rgds,
Jean-Luc

Re: Awk - using one field separator, then another?

Rob_132 — Thu, 18 Sep 2003 10:31:54 GMT

Re: Awk - using one field separator, then another?

Rob_132 — Thu, 18 Sep 2003 10:34:13 GMT

Zero points

make that,

"It looks like you OWE Jean-Luc...."

Rob

Zero points

Re: Awk - using one field separator, then another?

Rob_132 — Thu, 18 Sep 2003 10:37:28 GMT

Zero points

(sorry!!)...AND *Y O U* will be the one to promote Jean-Luc to *W I Z A R D*

Too compelling to pass up, I'd say!

Rob

Zero points

Re: Awk - using one field separator, then another?

Tony Walker — Thu, 18 Sep 2003 10:41:46 GMT

Thanks for the input Rob, I'll give you some points you didn't ask for later:) So, you the points system then...

Re: Awk - using one field separator, then another?

Steven E. Protter — Thu, 18 Sep 2003 11:02:25 GMT

Come on, make Jean-Luc a Wizard.

I would like to see a complete example.

SEP

Re: Awk - using one field separator, then another?

Tony Walker — Thu, 18 Sep 2003 12:28:15 GMT

Steve - just for you..

uptime|awk -F: '{MYVAR=$4;split(MYVAR,mv,",");print mv[1]}'

Re: Awk - using one field separator, then another?

Hein van den Heuvel — Thu, 18 Sep 2003 12:59:39 GMT

The -F argument and corresponding FS variable is a full regular expression. So in this case you can just use both "," and ":" as seperators giving:

uptime|awk -F[:,] '{print $7}'

fwiw,
Hein.