String Expression looking for "("

  • Thread starter Thread starter Garry
  • Start date Start date
G

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
 
Hi Garry

try

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

Cheers
JulieD
 
Spot on JulieD, thanks very much for your time


JulieD said:
Hi Garry

try

pname: IIf(InStr([fullname],"(")>0,Left([fullname],InStr([fullname],"(")-1),[fullna
me])
Cheers
Click to expand...
JulieD

Garry said:
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
Click to expand...
Click to expand...
 
you're welcome ..
Garry said:
Spot on JulieD, thanks very much for your time


JulieD said:
Hi Garry

try

pname:
Click to expand...
IIf(InStr([fullname],"(")>0,Left([fullname],InStr([fullname],"(")-1),[fullna
me])
Cheers
Click to expand...
JulieD

Garry said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top