Removing characters

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Hi
i have a lot of records with data as follows:
+44(0193)5555685

i need to get rid of the +44 plus the two brackets - is there an easy way to
do this please

tks
A
 
Create a query.

Change it to an Update query (Update on Query menu.)

In the Update row under this field, enter:
Replace(Replace([Field1], "+44(", ""), ")", "")
but use your field name instead of Field1.

The +44( and the closing brackets will be replaced.
 
Backup your database and try this --
Replace(Replace([YourFieldName], "+44(",""),")","")

This is assuming that the field always has +44( together.
If separate then use this --
Replace(Replace(Replace([YourFieldName], "+44",""),"(",""),")","")
 
Back
Top