Formula needed to exclude data in a field 1

[Jonesxx]

Hi

Using Crystal 8.5, I'm trying to create a formula that brings back everything to the left of a string field and excludes the deatils to the right e.g:

Joe Bloggs (Ireland)

I only want to get back Joe Bloggs, Ireland should be excluded

The table and field used are Sales.Salesman

Any help with the formula syntax would be great

Thanks v m

 

[BobSuruncle]

Try this:

If Instr({Sales.Salesman},"(") > 0 then
Left({Sales.Salesman},Instr({Sales.Salesman},"(")-1)
else ({Sales.Salesman}

Bob Suruncle