1 Reply Latest reply on Aug 31, 2012 10:36 AM by philmodjunk

    "List" function

    gcatnine

      Summary

      "List" function

      Product

      FileMaker Pro

      Version

      12v2

      Operating system version

      all

      Description of the issue

      I would like to know it the result of the function "LIST" is correct when a field is empty:
      f.i.
      field1 = "A"
      field2 = empty
      field3 = "B"
      List(field1;field2;field3) =
      A
      B

      and not
      A

      B

      I would expect that the returned list has an empty value

      Steps to reproduce the problem

      see description

      Expected result

      value1
      empty value
      value3

      Actual result

      value1
      value3

      Exact text of any error message(s) that appear

      n.a.

      Configuration information

      n.a.

      Workaround

      n.a.

        • 1. Re: "List" function
          philmodjunk

          This is an expected and often very useful feature of the list function.

          Quoting from FileMaker help entry on the list function:

          Returns a concatenated list of non-blank values (separated by carriage returns) for a field or fields.