removing part of a series record name for merging purposes...

Hi everyone, Oliver here.

Just had a (hopefully!) straight forward question;

If I have an array with Properties with and records such as below:

Prop1                   Prop2          Prop3           Prop4

AAA-001               Data1          Data2               ---

AAA-002                  ---               ---                Data3 

AAA-003                  ---               ---                Data4

AAA-001 (abc)         ---               ---                Data5

AAA-002 (abc)       Data6           ---                   ---

AAA-003 (abc)         ---              Data7              ---

How can I remove the part of the string from the Prop1 records consisting of "(abc)" to get:

Prop1                   Prop2          Prop3              Prop4

AAA-001               Data1          Data2              Data5

AAA-002               Data6             ---                 Data3 

AAA-003                  ---             Data7              Data4

Cheers everyone.

PS: Thanks Malcolm Baird for the help last time on changing a record to a property, it worked!