×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How to enter a CR character in a calculation field

How to enter a CR character in a calculation field

How to enter a CR character in a calculation field

(OP)
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

RE: How to enter a CR character in a calculation field

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


RE: How to enter a CR character in a calculation field

(OP)
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

RE: How to enter a CR character in a calculation field

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close