Extract data preceding "#http:"

[EllenM]

Hello,
I have a field that contains data that looks like this:

§74.101#http://ecfr.gpoaccess.gov/cgi/t/text/text-idx
c=ecfr&sid=3cebab99372b0496f3e6d22cefed18da&rgn=div8&view=text&node=21:1.0.1.1.27.1.31.1&idno=21#


Using an update query, I'd like a new field with the data that precedes the
"#http://". In the case of my example, it would be "§74.101".

Thanks in advance for your help.

Ellen

 

[EllenM]

Hello,
I did a bit of experimentation and found that
Left([table1]!Field1,(InStr([table1]!Field1,"#")-1))
works.