Hi,

Not really sure if I posted in the right forum directory, but anyways...

The problem I've stumbled across is "How to tell Filemaker Pro not to insert carriage return if the current line is the last one?". That is to create labels.

My calculation field goes like that:

Case (

IsEmpty ( First ); " " & Last & "¶";

IsEmpty ( Last);" " & First & "¶";

" "&First & " " & Last & "¶"

) & "" &

If ( IsEmpty ( Nickname ) ; "";" " & GetField ( "Nickname" ) & "¶" ) & "" &

If ( IsEmpty (Title) ;"" ;" "& TextSize (GetField ("Title") ; 8 ) & "¶")& "" &

If ( IsEmpty (Company ) ; "" ;" "& TextStyleAdd (GetField ("Company") ; Bold ) & "¶") & "" &

If ( IsEmpty ( Division ) ; "" ; " "& GetField ("Division") & "¶") & "" &

If ( IsEmpty ( ${Street 1 (Line 1)} ) ;"" ;" "& GetField ( "${Street 1 (Line 1)}" ) & "¶") & "" &

If ( IsEmpty ( ${Street 1 (Line 2)} ); "" ; " "&GetField ( "${Street 1 (Line 2)}" ) & "¶") & "" &

If ( IsEmpty ( City 1 ) ; "" ; " "&GetField ( "City 1" ) & "¶") & "" &

Case (

IsEmpty ( State 1 & Zip 1 ) ;"" ;

IsEmpty ( State 1 );" "& GetField ( "Zip 1" ) & "¶";

IsEmpty ( Zip 1 ); " "& GetField ( "State 1" ) & "¶";

" "&GetField ( "State 1" ) & ", " & GetField ( "Zip 1" ) & "¶"

) & "" &

If ( Country 1 = "UK" ; "" ;" " & GetField ( "Country 1" ) )

Thanks

AFAICS, the most simple solution would be to put the CR at the beginning rather than at the end, so each non-empty result brings along its very own CR.

First thing: you should use the field's name directly, instead of GetField(); for example:

Case ( not IsEmpty ( FirstName ) ; FirstName )

Re your question, I suggest you study the List() and Trim() functions.

Hi tchemiy, and Welcome to the Forums

Not really sure if I posted in the right forum directory, but anyways...

This topic has been moved from "FileMaker Product Family → FileMaker Pro 12" to "Database Schema & Business Logic → Calculation Engine (Define Fields)".

This forum is for the discussion of the new features of the FileMaker Pro Family of

Products.

Lee

Thanks very much, comment! The list function did the job perfectly!!