Shell Programming and Scripting

Hello All,

I am new to unix scripting, I have an urgent issue

Is it possible to do a group by on the last column and then a page break on the text file.
For example I have a text file, below is the example data

STRT 2154081~VA ~23606 ~TM14~8506~1485
STRT 2130893~VA ~23602 ~TM15~8602~1586
STRT 2154051~VA ~23602 ~TM15~8802~1588
STRT 2085746~VA ~23662 ~TM17~8362~1783
STRT 2121415~VA ~23662 ~TM17~8362~1783
STRT 52773~VA ~23662 ~TM17~8362~1783
STRT 87121~VA ~23662 ~TM17~8362~1783
STRT 166299~VA ~23185 ~TM41~9085~4190
STRT 167311~VA~23185 ~TM41~9085~4190
STRT 180099~VA ~23185 ~TM41~9085~4190
STRT 2007255~VA ~23185 ~TM41~9085~4190

When I print the report, I would like to have the data printed out in the below format.

STRT 2154081~VA ~23606 ~TM14~8506~1485 (page 1)

STRT 2130893~VA ~23602 ~TM15~8602~1586 (page 2)

STRT 2154051~VA ~23602 ~TM15~8802~1588 (page 3)

STRT 2085746~VA ~23662 ~TM17~8362~1783 (page 4)
STRT 2121415~VA ~23662 ~TM17~8362~1783
STRT 52773~VA ~23662 ~TM17~8362~1783
STRT 87121~VA ~23662 ~TM17~8362~1783

STRT 166299~VA ~23185 ~TM41~9085~4190 (page 5)
STRT 167311~VA~23185 ~TM41~9085~4190
STRT 180099~VA ~23185 ~TM41~9085~4190
STRT 2007255~VA ~23185 ~TM41~9085~4190


Thank you

Try this:

Code:

gawk \
'{
if(NR == 1)
{
  prev = $NF
  print $0
}
else
{
  if($NF == prev)
    print $0
  else
  {
    print "\f"
    print $0
    prev = $NF
  }
}
}' file

Thanks a lot Cooldude, you saved my day
Thanks again

Or:

Code:

awk  '$0=_[$NF]++?$0:"\f"RS$0' file

Thank you radoulov