I'm very sorry for any confusion. I realize that I probably was not succinct in my posting. An example of the data from the first file would be:

Product # Prod Name Univers ID

A101 something 123

A102 else 456

A103 it 789

A104 the 012

An example of data from the second file would be

Product # Product Name Univers ID

A102 else

A103 it

An example of the file that I want to generate would be:

Product # Product Name Univers ID

A102 else 456

A103 it 789

Does this make more sense? Again, I apologize for not being more clear. I'm an obvious perl novice and am trying to get my head around the language. Any help would be greatly appreciated.