Remove text that precedes "#"

  • Thread starter Thread starter EllenM
  • Start date Start date
Hello,
I have a string that looks like this:
§74.1321#http://ecfr.gpoaccess.gov/cgi/t/text/text-idx?c=ecfr
rgn=div8&view=text&node=21:1.0.1.1.27.2.31.18&idno=21#

How can I remove the characters that precede the first "#", so that string
will look like this:

#http://ecfr.gpoaccess.gov/cgi/t/text/text-idx?c=ecfr
rgn=div8&view=text&node=21:1.0.1.1.27.2.31.18&idno=21#

I know I'll need an update query.

Thanks in advance for your help.

Ellen
Click to expand...

Update YourTable Set YourTable.[FieldName] =
Mid([FieldName],InStr([FieldName],"#")+1)
 
Back
Top