How can I parse a field and link to a parent 'object'

Hi completely new to Knack. I have an object 'Trans' with a field called 'Customer Description' that contains "NAME: Tony Wright (ID 9) COUPON: "

I want to link to a parent object 'Clients' where I have a record for 'Tony Wright'

It is a one-to-many relationship between Clients and Trans and I have created Trans records via CSV inport.

Obviously there are only some of the Trans records for Tony the other records belong to other clients.

How can I do this?

Thanks.

Online Database Expert