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

[_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

 

[fredg]

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

In a query:
NewColumn:Mid([FullField],1,Instr([FullField],"#")-1)

 

[Ken Snell [MVP]]

UPDATE TableName
SET FieldName =
Left(FieldName, InStr(FieldName, "#") - 1);

 

[_Bigred]

Thanks Fred I used your expression and it worked like a charm.

Appreciate your time & attention,
_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

In a query:
NewColumn:Mid([FullField],1,Instr([FullField],"#")-1)

 

[_Bigred]

Thank Ken, I ended up using Fred's expression and it worked great.

I appreciate your post and time,
_Bigred