UNIX for Dummies Questions & Answers

I want to extract the last rows of a data file, similar to that one below:

C1 xxx
C2 rrr
C3 ttt
....
Cn-1 hhh
Cn bbb
C1 yyy
C2 sss
C3 uuu
...
Cn-1 iii
Cn ccc
...

I just want to extract the final rows between C1 and Cn at each data file. n is not a constant, but depends on the data itself. Is there a way to do this with awk?

Thank you,
n

Assuming n is a sequence of numbers and just a single letter C before the n...

Code:

awk '{arr[$1]=$2;K=$1}END{
  for(i in arr){
    gsub(/C/,"",K)
    I=i;gsub(/C/,"",i)
      if(i<=K) print I,arr[I]}}' infile

thanks malcomex999