How to remove "(text)" from a string

[Soundneedle]

I have a string value that is equal to:
My neighbor has a dog (Fido).

How can I strip off the "(Fido)" part using VBA?

[pietlinden]

why would you want to do that with VBA? In VBA, you would have to do
this a record at a time, while using SQL you could do the *entire*
table at once.

use InStr() to get the position of the first open parenthesis, then
subtract one, then take everything to the left of it (Left$) and
finally Trim$ it.

[Soundneedle]

I should elaborate....

Each string value will end in "(sometexthere)". Example
My first string (One)
My second string (Two)
My last string (Last)

What's the simplest code that will return everything to the left of the
first "("? I think it uses Left and Len. I just haven't figure it out
yet....

[Soundneedle]

Just figured it out:
left([subject],instr([Subject],"(")-1)

[Trevor Best]

Soundneedle wrote:

I have a string value that is equal to:
My neighbor has a dog (Fido).

How can I strip off the "(Fido)" part using VBA?

Replace(text,"(fido)","")

--
[Oo=w=oO]