Remove text string

  • Thread starter Thread starter EllenM
  • Start date Start date
E

EllenM

Hello,
I've like to remove the following string from a field:
#~lrd/cfr25-32.html#
Can that be done with an update query? Does the # need some kind of escape
character?

Thanks in advance,
Ellen
 
Hello,
I've like to remove the following string from a field:
#~lrd/cfr25-32.html#
Can that be done with an update query? Does the # need some kind of escape
character?

Thanks in advance,
Ellen
Click to expand...

You wish to remove that string from a larger string?
Back up your table data first.
Then run an Update query.

Update YourTable Set YourTable.FieldName =
Replace([FieldName],"#~lrd/cfr25-32.html#","")
 
Back
Top