Selecting Last Records 2

[thunderkid]

How do I use awk to select last record in data below:

23 100 345 F0001
24 400 241 F0002
25 234 213 F0002
30 234 211 F0003
31 212 211 F0003
32 112 211 F0003
26 212 211 F0004

desired format
23 100 345 F0001
25 234 213 F0002
32 112 211 F0003
26 212 211 F0004

Thanks
thunderkid

 

[PHV]

A crude starting point:
awk '{if(NR>1&&f!=$4)print x;f=$4;x=$0}END{print x}' /path/to/input

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[thunderkid]

PHV,
Works great. Thanks!
Have a star!

thunderkid

 

[duncdude]

Nice. PHV is good at this isn't he!


Kind Regards
Duncan

 

[ranjit]

PHV - would it be possible to explain the logic of this script?

Many thanks

 

[PHV]

The logic of this script is to save the current line on each iteration and to print the last saved line each times the value of $4 changes.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886