How to enter a CR character in a calculation field

[rusmuscat]

Using a calculation I'm trying to create a single-field maiiling label that would lay out like this:

FistName LastName
Address1 Address2
City State Zip
COUNTRY

How do I tell FileMaker to put a Carriage Return at the end of each respective line in the calculation field.

TIA,

Vlad

 

[JeanW]

If you have your fields:

FistName
LastName
Address1
Address2
City
State
Zip
COUNTRY,
use a calculation, result text:
FirstName & " " & LastName & "¶"&
Address1 & " " & Address2 & "¶" &
City & " " & State& " " & Zip & "¶"&
Country

 

[rusmuscat]

Thank you, Jean.

In FileMaker this worked. But when I created a script that copies the contents of the resulting field via the (Mac) Clipboard to the address window of Endicia (a postal mailing program), the returns don't carry over: I get

FirstName LastNameAddressCity State ZipCountry -- all run together on a single line.

Curiously, though, if I drag-and-drop the address from FileMaker to Endicia, the formatting is retained:

FirstName LastName
Address
City State Zip
Country

I suppose I can live with the drag-and-drop, but now my curiosity is piqued as to why this is happening.

Vlad

 

[JeanW]

In the calculation field, FileMaker will use the "¶" to insert a paragraph carriage return in the result of the formula.
In FM +7 you can even remove the "".

You can use backslashes to preserve special operator characters, such as double quotation marks or a carriage return character, simply as characters within a string (instead of as operators).

Look also what the carriage return export can do for you.