Replace text from a specific character

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I foolishly changed my text field to a hyperlink and then changed it back
again and now all my e-mail addresses show as e.g.
(e-mail address removed)#mailto:p[email protected]
I can recover most of them from my backup but wondered if there is a way of
using the update query to remove everything from the # onwards.
Thanks for any help
Sheila
 
Update MyTable
Set MyField = Left([MyField], Instr([MyField],'#')-1)

Ought to do it

Pieter
 
Fantastic, worked a treat, thanks

Pieter Wijnen said:
Update MyTable
Set MyField = Left([MyField], Instr([MyField],'#')-1)

Ought to do it

Pieter

Sheila D said:
I foolishly changed my text field to a hyperlink and then changed it back
again and now all my e-mail addresses show as e.g.
(e-mail address removed)#mailto:p[email protected]
I can recover most of them from my backup but wondered if there is a way
of
using the update query to remove everything from the # onwards.
Thanks for any help
Sheila
Click to expand...
Click to expand...
 
Back
Top