topic Re: awk to print last line in Operating System - Linux

awk to print last line

lawrenzo_1 — Tue, 21 Aug 2007 07:08:11 GMT

Hi,

how can I get awk to print the last line and first field from a command output?

I know I can do :

command | awk '/rows/ {print $1}'

but I was wondering is there another method incase there are mulitple lines containing rows?

command output is:

USER_NAME RESPONSIBILITY
--------------- ------------------------------
abc

USER_NAME RESPONSIBILITY
--------------- ------------------------------
def

141 rows selected.

Re: awk to print last line

Pete Randall — Tue, 21 Aug 2007 07:16:58 GMT

Not sure about awk but I know you can do it with sed:

# print last line of file (emulates "tail -1")
sed '$!d'

Pete

Re: awk to print last line

lawrenzo_1 — Tue, 21 Aug 2007 07:19:02 GMT

super,

that will do me!

Thanks Pete.

Re: awk to print last line

Ivan Krastev — Tue, 21 Aug 2007 07:21:26 GMT

# print the last line of a file (emulates "tail -1")
awk 'END{print}'

regards,
ivan

Re: awk to print last line

James R. Ferguson — Tue, 21 Aug 2007 07:21:49 GMT

Hi Chris:

With Perl that's easy:

# command|perl -nlae 'print $F[0] if eof'

Regards!

...JRF...

Re: awk to print last line

James R. Ferguson — Tue, 21 Aug 2007 07:24:22 GMT

Hi (again):

...I should hasten to add, that if you want the whole last line, simply do:

# command|perl -nle 'print if eof'

...otherwise what I gave above prints the _first_ filed of the _last_ line only.

Regards!

...JRF...

Re: awk to print last line

Dennis Handly — Tue, 21 Aug 2007 07:27:27 GMT

You could of course use tail then awk. Or use this script that saves field 1 of the last line:
command | awk '
{
SAVE = $1
}
END { print SAVE } '

Re: awk to print last line

lawrenzo_1 — Tue, 21 Aug 2007 07:29:51 GMT

Thats the ticket ....

Thank you everyone.

Chris.

Re: awk to print last line

Dennis Handly — Tue, 21 Aug 2007 07:35:45 GMT

It looks like you can combine Ivan's with mine and get:
awk 'END { print $1 } '