AnsweredAssumed Answered

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

Question asked by darrenburgess on Jun 18, 2015
Latest reply on Jul 2, 2015 by TSGal

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

Outcomes