find and use specific text immediately following specific characters

Hi,

I'm currently using

Please Login or Register  to view this content.

to locate a particular set of characters within a string, and to print specific text in the cell. But there is also specific text embedded within the cell that I'm searching which needs to be included in the resulting cell. Here's an example: Sample2.xlsx

Except that although I've currently hard coded "1432xht" into the sequence to be typed, I need it to find the text within the parenthesis immediately to the right of DUP1. Anyone out there know how?

Thanks!
Rob