tkessler45

Combining string values?

Discussion created by tkessler45 on Feb 29, 2016
Latest reply on Feb 29, 2016 by user19752

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.

Outcomes