Eliminate Multiple Mention of Same Word in Field
Working on FMP 8.5
We have individual items available in many different colors that we need designated into MASTER COLOR CATEGORIES for our web site.
PRODUCTS AVAILABLE IN: Cardinal Red, Forest Green, Kelly Green, Navy Blue, Royal Blue, Bubblegum Pink, Texas Orange, White
We have created a calculation to translate those each of those names into one field --> MASTER COLOR CATEGORIES. The above data would return:
MASTER COLORS CATEGORIES: Red, Green, Green, Blue, Blue, Pink, Orange, White
Problem: Our web site software rejects the above data because of multiple mentions of the same word.
We need a script or calculation to eliminate duplicate mentions of the same word in a field and return MASTER COLOR CATEGORIES like this.
MASTER COLORS CATEGORIES NEW: Red, Green, Blue, Pink, Orange, White
Any ideas would be welcome.