AnsweredAssumed Answered

Eliminate Multiple Mention of Same Word in Field

Question asked by jcarey on Jul 10, 2009
Latest reply on Jul 10, 2009 by etripoli


Eliminate Multiple Mention of Same Word in Field


 Hi Everybody_


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.


For example:

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.