Hi, I have multiple large files which consist of the below format:

I am trying to write an awk or sed script to remove all occurrences of the 00 record except the first and remove all of the 80 records except the last one.

Any help would be greatly appreciated.

Is this what you want...?

awk 'NR==1
s=0
NR>1 && !/^00/
/^00/{s=1}
END{if(s){print}}' file

Thanks for your reply.

Yes that is along the lines of what i need.

That script removes the 00 records except the 1st

I also need it to remove all the 80 records but leave the last one as it is.

Any ideas....?

Forgot to add this condition..

try

awk 'NR==1
s=0
NR>1 && !/^00|^80/
/^80/{s=1}
END{if(s){print}}' file

It's getting there now

That edit to the script removes all the 80 records including the last one.

How could i get it to leave the last 80 record there??

Try now

awk '!s && /00/{s=1;print}
/80/ && a{K=$0;for(i=1;i<=a;i++){print X[i]};a=0}
!/^00|80/{X[++a]=$0}
END{if(K){print K}
for(i=1;i<=a;i++){print X[i]}
}' file

Same again pamu

Everything is perfect apart from the final line of the file which should be the 80 record but is the 70 record