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!