awk to print last line

[lawrenzo_1]

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.

[Pete Randall · Accepted solution]

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

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


Pete

[lawrenzo_1]

super,

that will do me!

Thanks Pete.

[Ivan Krastev]

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


regards,
ivan

[James R. Ferguson]

Hi Chris:

With Perl that's easy:

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

Regards!

...JRF...

[James R. Ferguson]

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...

[Dennis Handly]

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 } '

[lawrenzo_1]

Thats the ticket ....

Thank you everyone.

Chris.

[Dennis Handly]

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