8 Replies Latest reply on Jul 2, 2015 2:01 PM by TSGal

    Calcuation dialog:  line wraps if there is more than one tab in the line

    darrenburgess

      Summary

      Calcuation dialog:  line wraps if there is more than one tab in the line

      Product

      FileMaker Pro

      Version

      14.0.1 advanced

      Operating system version

      OS 10.10.3

      Description of the issue

      When there is more than one tab within a quoted string in a line in the calculation dialog, the line wraps at the second tab

      Steps to reproduce the problem

      See attached image.  You can see the first and second tabs indicated in the marked up image.  Both tabs are part of a string enclosed in double quotes.  It seems this is repeatable when the second quote is contained within a function.  In the example, this is the substitute function, but I was also able to reproduce use the filter function.

      Expected result

      Line should not wrap when there is a second tab

      Actual result

      Line wraps, disrupting intended formatting of the calculation

      Exact text of any error message(s) that appear

      none

      Configuration information

      Here is the calculation:
      Let ( [

             $fieldList = SuperTrim ( $_list_of_fields )
           ; ~fieldsParsed = "     '" & Substitute ( $fieldList ; "¶" ; "',¶'" ) & "'"

      ]

           ; List (

                  "SELECT"
                ; ~fieldsParsed
                ; "FROM " & $_table_name

                )
      )

      Workaround

      none

      Specify_Calculation.png