Remove duplicates in each record of a text field
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?