Doe,John#hpttw30-- [How would I delete from # to the right]?

  • Thread starter Thread starter _Bigred
  • Start date Start date
B

_Bigred

I have a table I imported a HTML into, unfortunately the name column

gives me (E.G) Doe, John#http:/www.r02934-92340.com/0340394

Is there a way I can setup a query to eliminate everthing from (including)
the # to the right?

I would want the pound sign to be eliminated also, and fortunately every
single name in this column has a pound sign and then a URL after it.

TIA,
_Bigred
 
I have a table I imported a HTML into, unfortunately the name column

gives me (E.G) Doe, John#http:/www.r02934-92340.com/0340394

Is there a way I can setup a query to eliminate everthing from (including)
the # to the right?

I would want the pound sign to be eliminated also, and fortunately every
single name in this column has a pound sign and then a URL after it.

TIA,
_Bigred
Click to expand...

In a query:
NewColumn:Mid([FullField],1,Instr([FullField],"#")-1)
 
Thanks Fred I used your expression and it worked like a charm.

Appreciate your time & attention,
_Bigred


fredg said:
I have a table I imported a HTML into, unfortunately the name column

gives me (E.G) Doe, John#http:/www.r02934-92340.com/0340394

Is there a way I can setup a query to eliminate everthing from
(including)
the # to the right?

I would want the pound sign to be eliminated also, and fortunately every
single name in this column has a pound sign and then a URL after it.

TIA,
_Bigred
Click to expand...

In a query:
NewColumn:Mid([FullField],1,Instr([FullField],"#")-1)
Click to expand...
 
Thank Ken, I ended up using Fred's expression and it worked great.

I appreciate your post and time,
_Bigred
 
Back
Top