Omitting space when middle name not present

I have a (predominantly search-oriented) Full Name field consisting of a
calculation:
First Name & " " & Middle Name & " " & Last Name

How do I avoid the space related to the Middle Name, when the field is
empty? Haven't been able to find the right function for that, though
it's probably quite simple :-) I thought of filtering, but that allows
characters and can't seem do disallow double spaces...

Thx in advance!

:-) Esben

Mail: nameasofabove_h@get2net.dk

Re: Omitting space when middle name not present

esha@nospamget2net.dk (Esben) writes:

> I have a (predominantly search-oriented) Full Name field consisting of a
> calculation:
> First Name & " " & Middle Name & " " & Last Name
>
> How do I avoid the space related to the Middle Name, when the field is
> empty? Haven't been able to find the right function for that, though
> it's probably quite simple :-) I thought of filtering, but that allows
> characters and can't seem do disallow double spaces...

http://filemaker.com/help/FunctionsRef-383.html

Jens

Re: Omitting space when middle name not present

Jens Teich wrote:

> esha@nospamget2net.dk (Esben) writes:
>
> > I have a (predominantly search-oriented) Full Name field consisting of a
> > calculation:
> > First Name & " " & Middle Name & " " & Last Name
> >
> > How do I avoid the space related to the Middle Name, when the field is
> > empty? Haven't been able to find the right function for that, though
> > it's probably quite simple :-) I thought of filtering, but that allows
> > characters and can't seem do disallow double spaces...
>
> http://filemaker.com/help/FunctionsRef-383.html
>
> Jens

I get the message: "There are too many parameters in this function",
when I add to the above:

& Trim (Full Name;1;1)

which should be the rigth syntax, as I reed the above URL

is my "&" a mistake and in that case - what's the right character?


:-) Esben

Mail: nameasofabove_h@get2net.dk

Re: Omitting space when middle name not present

First name & " " &
If ( not isEmpty ( Middle Name ) ; Middle Name & " " ; "" ) &
Last Name

Basically, if there is a Middle Name, you insert Middle Name and a space
after it. Otherwise, null.

Matt

Esben wrote:
> I have a (predominantly search-oriented) Full Name field consisting of a
> calculation:
> First Name & " " & Middle Name & " " & Last Name
>
> How do I avoid the space related to the Middle Name, when the field is
> empty? Haven't been able to find the right function for that, though
> it's probably quite simple :-) I thought of filtering, but that allows
> characters and can't seem do disallow double spaces...
>
> Thx in advance!
>
> :-) Esben
>
> Mail: nameasofabove_h@get2net.dk

--
Free FileMaker Technique Demos: http://www.VirtualVermont.com/FMP

My Custom Functions:
http://www.briandunning.com/filemaker-custom-functions/resul ts.php?keyword=wills

Re: Omitting space when middle name not present

> & Trim (Full Name;1;1)

TrimAll (Full Name;1;1)

Jens

Re: Omitting space when middle name not present

Matt Wills wrote:

> First name & " " &
> If ( not isEmpty ( Middle Name ) ; Middle Name & " " ; "" ) &
> Last Name
>
> Basically, if there is a Middle Name, you insert Middle Name and a space
> after it. Otherwise, null.
>
> Matt

thanks!

Esben

Re: Omitting space when middle name not present

Jens Teich wrote:

> > & Trim (Full Name;1;1)
>
> TrimAll (Full Name;1;1)
>
> Jens

Thanks!/Danke dir (you responded within 6 minutes of the first post -
wow!)

Esben