UNIX for Dummies Questions & Answers

Hi everyone! I have something like the following records in a file:

ID: 1
Name: A
Age: 23

ID: 2
Name: B

ID: 1
Activity: Climbing

ID: 3
Name: C

ID: 3
Activity: Skating

I want to capture the records where the field Age exists AND the records that have the same ID as the one where the Age existed. So in the example above, only record with ID:1 is printed to the output file:
ID: 1
Name: A
Age: 23

ID: 1
Activity: Climbing

ID:2 is ignored because it doesn't have neither the AGE field nor any other ID:2 record follows; so as for ID:3, because the field AGE is missing.

I hope I have explained this well and that it is possible to do this with UNIX commands.

Thanks in advance, Atrisa

I suppose in a shell you could put all fields in arrays by id, and then walk the age arrray by id printing all for good ages. Your problem is a bit of a sort and join filtering with sparse matrix.

What software produced this output? It is often easier to process the data in the original programming language (whatever that is?) with direct access to the database rather than trying to use unix Shell to process what amounts to print layout.

Ps. Please post data samples in Code Tags.

Code:

 awk -vRS="" -vFS="\n"  '/Age/{re=$1} $0~re{print }'  file

Thanks everyone. JavaHater's command did the trick. thanks again.