6 Replies Latest reply on Feb 29, 2016 6:28 PM by user19752

    Combining string values?

    tkessler45

      I have a situation where my FileMaker solution generates two global variables that each contain a list of stereotyped string values separated by carriage returns, such as the following:

       

      Global 1:

      "first"

      "second"

      "third"

       

      Global 2:

      "fourth"

      "first"

      "third"

       

      I would like to create a calculation, or some approach, that can combine these values, such that the following results when this calculation is performed:

       

      "first"

      "second"

      "fourth"

      "third"

       

      The idea here is regardless of the ordering, that any duplicates are stripped and the final listing that is stored in the third variable is a combination of the two input lists. I'm hoping there is a solution, but from what I am seeing I cannot find good tools in FileMaker for parsing and manipulating string values.