It is a know error. It is a problem with the way FileMaker is handling calculated text and displaying it.
Your problem look like this:
The calculation you made is in my opinion correct, but it is failing due to what I guess is a bug, adding a space AFTER the return code in the beginning of the new line. The calculation used in the field to the left is:
"Hello, my name is Carsten ¶" &
"I am from Denmark ¶" &
"and I am using FileMaker all the day"
The calculation used in the field to the right is:
"Hello, my name is Carsten ¶
I am from Denmark ¶
and I am using FileMaker all the day"
It is not a problem with the linebreaks caused by your text to reach the end of the line. It is only when you use the FileMaker return code, the ¶.
You should report it as a bug to FileMaker, I will also. And in the meantime you need to change the code as I showed here.
Thanks for your comments. The space after the carriage return has allowed me to fixed my problems.
"From the land down under”
Feel free to press the button marking my answer as correct: Also to help other people facing the same problem.
Pressed the button before then I became confused when it turned and showed " Unmark as Correct".
Thanks, from the land nearly at the top, at least when counting Greenland.
And, I still assume that it is a bug that FileMaker is adding the space after the return:-)
I don't see why it is a bug. If you have a space character within quotes, which is what the OP had apparently, you WANT Filemaker to treat it as a live space, not disregard it just because it follow a pilcrow.
I have created a test file "Email Test" which has a brief email script which now seem to line up my data.
Hopefully I have created it such that it seems to line within the email.
PS I was surprised how quickly I could create the test file and possible in the future this may be a way of explaining the issue?
SendMail.fmp12.zip 68.0 K
"Re:" & ¶ &
"Insured: "& " " & Email Test::InsuredName & ¶ &
"Date of Incident:" & " " & Email Test::LossDate & ¶ &
"Policy No:" & " " & Email Test::PolNo & ¶ &
"Policy Excess:" & " " & Email Test::Pol_Excess & ¶ &
"Our Claim Ref:" & " " & Email Test::Broker Claim Ref# & ¶ & ¶ &
"Please note the following:" & ¶
An interesting thought: This is one of the few, if not the only, place where the same operator will work both within a text string "text ¶" and outside "text" & ¶ ... with one difference that inside the text string you can have more of them without & between but then you get the unwanted " " before the next line.
I still believe that the extra space is a bug. You should report it: Report a Product Issue
Also, your use of spaces to align the second column will probably turn out to be problematic. Different fonts, email applications etc. may all render this different.
Have you considered generating a PDF and then send this with the email?
I have not seen the suggestion to use Char(13) instead of the pilcrow. Have you tried that?
"text label " & field & Char(13) &
also, I use a 'padding' method when trying to simulate "columns" in email:
I agree with Carsten that the receiver's email client may not accept the spacing as you intended (monospaced for example). You can attach text files (or Excel) as well as pdfs to email.
Carsten, I don't think this is a bug in FileMaker. The issue is when you wrote your calc you inserted a new line character (enter key) within the quotes. This puts a hidden character in your calc that is getting interpreted as a space. You should not insert a new line within quotes. If you rewrite your calc to "Hello, my name is Carsten¶I am from Denmark¶and I am using FileMaker all the day" everything works fine.