String Expression looking for "("

[Garry]

Hi all
I have a field [FullName] that sometime has for example
Ray Morris or
Bill Hughes (FR)
I am trying to get returned the names Ray Morris and Bill Hughes
in other words everything to the left of "("
What forme would the expression look like ?

many thanks Garry

 

[JulieD]

Hi Garry

try

pname:
IIf(InStr([fullname],"(")>0,Left([fullname],InStr([fullname],"(")-1),[fullna
me])

Cheers
JulieD

 

[Garry]

Spot on JulieD, thanks very much for your time

Hi Garry

try

pname: IIf(InStr([fullname],"(")>0,Left([fullname],InStr([fullname],"(")-1),[fullna
me])

Cheers

JulieD

Hi all
I have a field [FullName] that sometime has for example
Ray Morris or
Bill Hughes (FR)
I am trying to get returned the names Ray Morris and Bill Hughes
in other words everything to the left of "("
What forme would the expression look like ?

many thanks Garry

 

[JulieD]

you're welcome ..

Spot on JulieD, thanks very much for your time

Hi Garry

try

pname:

IIf(InStr([fullname],"(")>0,Left([fullname],InStr([fullname],"(")-1),[fullna

me])

Cheers

JulieD

Hi all
I have a field [FullName] that sometime has for example
Ray Morris or
Bill Hughes (FR)
I am trying to get returned the names Ray Morris and Bill Hughes
in other words everything to the left of "("
What forme would the expression look like ?

many thanks Garry