AnsweredAssumed Answered

Remove duplicate values from a single field

Question asked by Hoochimagoo on Jun 5, 2017
Latest reply on Jun 5, 2017 by coherentkris

Hi, I have multiple text fields that allow checkbox value list entries of text strings of up to 10 words.  These multiple lists are then collected (excuse my poor terminology) into a single text field separated by a ",".  Some of the value text strings are duplicates as they have come from different value lists.  I was wanting to remove the duplicate text strings from this single field.  Could someone please direct me to a fix for this?

 

I came across this from another discussion:  FileMaker Custom Function:RemoveDuplicates ( Text )

 

But was not sure if this would work for a text string or simply a single word.

 

Thank you. 

Outcomes