Perl can definitely do what you want. As could most other languages, though it will be easier in Perl than many. Even so, the complexity, or rather, the non-uniformity of the record structure is such that it is definitely non-trivial.

If your not in a hurry for your results, then it would be an ideal project to get you up to speed on perl, you will learn a great deal getting this right.

If however, you are in a hurry, you should seriously consider hiring the services of a programmer experienced in Perl to do this for you. You can then learn from seeing what he produces, and you will be better set for tackling the next task yourself.