Blank fields in concatenation

[Rainy Pass]

The following works but, there has got to be a better way.

What can be done to incorporate this into a Custom Function that can be used in other fields in this table or in other tables?

Any suggestions to improve this calc would be apreciated.

------------------------------------------

//Combine address fields into a label like field without any blank lines if data is missing

Let ( [ FN = FirstName_t ; LN = LastName_t; MN=MiddleName_t;CO=Company1_t;DP=Department1_t;L1=Address1_t;L2=AddressLineTwo1_t;CY=City1_t;ST=State1_t;Zip=Zip1_t;CT=Country_t] ;

Case(

FN="" and MN="" and LN="";"";// No name

FN="" and MN="" ;LN &

[comment]

How about:

Substitute (

TrimAll (

Substitute (

TrimAll (

Title & " " & First & " " & Middle & " " & Last &

[Rainy Pass]

Thanks, much nicer. What is the character you are using to preserve a space with?

[comment]

It's called a 'paragraph' or 'section' sign (top left key on your Mac keyboard). But you can use any character which is not likely to be found in the text.

[Lee Smith]

Hi comment,

Is there a different keyboard for European users?

I have owned several different Macintosh computers, and I have never seen this as a separate key.

It is assesable by using the key combination of Option 6

According to Unipad, the

[Rainy Pass]

Thanks for the key combination Lee.

[comment]

Hm. I do have a non-standard keyboard, but my input menu is set to use the US keyboard, so I thought if it types what's engraved upon it...

So what IS the key to the left of 1?

[Lee Smith]

The ` GRAVE ACCENT and The TILDE ~ (Shift)

Lee

[comment]

Interesting... I have that to the left of "z", in the bottom row.

The weird thing is I have US keyboard set as my input, and still the Keyboard Viewer matches my physical keyboard's engravings. Is it possible that the OS recognizes the keyboard and adjusts accordingly?

[Lee Smith]

The Shift Key is next to the "Z" key. I have a Non Standard "wireless" M$ keyboard for my iBook. In order to use it, I had to install the software. I'm wonder if it isn't the Software that has done the remapping in some way to match the keyboard.

Lee

[comment]

I haven't installed anything for this keyboard, so that can't be it. If I ever get the chance, I will connect a standard Apple (US) keyboard and see if the Keyboard Viewer adjusts to match.

[Lee Smith]

What model are you using?

[comment]

The keyboard, you mean? It's an Apple Pro keyboard, but it has additional engravings to accommodate some specific uses. I gather now that the underlying Latin layout is European - but my OS is not.