Removing duplicate words from a field?
I have a question about how to remove duplicate word from a field. What id did, is I have a DB where I was creating descriptions, for printer parts that had calculation fields to get the printer names that followed the phrase "For use in:" all of the word after that are what I am using for yhe keywords. What I would like to accomplish though is remove all of the additional duplicated words that are in that field (printer may show multiple times, HP, lexmark, and so on) I created a 2 field DB and imported them in SKU_Item and Keywords. All of the words are separated by 1 space. Any sugestions wiould be helpfull.