Guys,
I have recently returned to FMP having used commercial programs for my
needs and FMP became too complex for the time I could spend on it. I
am only using v7. I'm trying to get the first name of a person from
their first name and last name. I know that I should have entered both
names separately then join them when required but I thought that
LeftWords ( Participants ; 1 )
should do the job but all I get is a number returned. Participants is
a field with "Chris Smith" in it.
[EMAIL PROTECTED]