AnsweredAssumed Answered

Remove duplicates in each record of a text field

Question asked by caterinap on Jul 10, 2014
Latest reply on Jul 14, 2014 by caterinap

Title

Remove duplicates in each record of a text field

Post

     Hello,

     My database has a text field. Some of the characters (only 4 possible: a,b,c,d) can be repeated multiple times in a given record. I would like to remove duplicate characters from each record of this field (and if possible sort characters, but this is not essential) as follows:

     my field: abcd / abbc / cbdc / bba / cabcb    into-->     my field: abcd / abc / bcd / ab / abc

     It seems that the custom functions  "UniqueValues" and "SortValues" in briandunning.com do that but unfortunately I don't have Filemaker Pro Advanced. I have Filemaker Pro 12.0v3. Is there a way to do that in a script?

     Thank you!

Outcomes