Remove text string

[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

 

[fredg]

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

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#","")

 

[EllenM]

Thanks so much, Fred!!