zachvaldez
asked on
Remove "(xxx)" from the field
I would like to update my records to stripped off the "(xxxxx)"from each record on a field in my table
For ex
US(Wash) >> US
Can(ONT)>>> CAN
Mex(AcA)>>> Mex
For ex
US(Wash) >> US
Can(ONT)>>> CAN
Mex(AcA)>>> Mex
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
perfect!
ASKER
Also If I have a record like
US Book-History,I would like to change it to read w/o the "-" as
US Book History
thanks