Removing characters

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
 
A

Allen Browne

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.
 
K

KARL DEWEY

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",""),"(",""),")","")
 
Top