Just a simple question, I have found some new paragraph " ¶ " symbol in a sample solution. Does new line can affect the result of calculation?
If your result is text, and that symbol is inside a string (literal text), then yes, this will change your text result.
Note that this symbol represents data. If you want to add a new line to format your calculation display, add it from the keyboard. That will not impact the calculation result.
Let([a=1;b=2];(a+b)*3) is identical to
Let ( [
a = 1 ;
b = 2
( a + b ) * 3
is different from "Hello¶Goodbye"
all depends on your calculation
Or to put it another way:
Quoted whitespace is literal and unquoted whitespace is ignored.
However, the Pilcrow symbol in the Calculation dialog is special. It is not any character (unicode or otherwise) that is entered from the keyboard or Char(). It is selected in the dialog. Do a test to see what happens with quoted and unquoted:
"Hello¶World""Hello" & ¶ & "World""Hello" & "¶" & "World"
"Hello" & ¶ & "World"
"Hello" & "¶" & "World"
Test these yourself and see what happens in the calculations dialog and what you get as a result. If you have FMPAdvanced, you can use Data Viewer to test.
Retrieving data ...