3 Replies Latest reply on May 26, 2017 5:46 AM by beverly

    Does new line can affect the result of calculation?

    AA

      Hello,

       

      Just a simple question, I have found some new paragraph " ¶ " symbol in a sample solution. Does new line can affect the result of calculation?

       

      Thanks,

      Andras

        • 1. Re: Does new line can affect the result of calculation?
          erolst

          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

          )

           

          but

          "Hello

          Goodbye"

           

          is different from "HelloGoodbye"

          1 of 1 people found this helpful
          • 2. Re: Does new line can affect the result of calculation?
            coherentkris

            all depends on your calculation

            • 3. Re: Does new line can affect the result of calculation?
              beverly

              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"

              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.

              Beverly