AnsweredAssumed Answered

Removing duplicate words from a field?

Question asked by MarcMcCall on Apr 4, 2012
Latest reply on Nov 29, 2013 by CoraWoolsey


Removing duplicate words from a field?


Hey guys,


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.