Remove text that precedes "#"

[EllenM]

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

 

[KARL DEWEY]

Try this --
Mid([YourField], InStr([YourField], "#")+1)

 

[fredg]

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

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

 

[EllenM]

Thanks so much!! Y'all are such a wonderful resource!!

Ellen