I'm working on a catalog using data merge. The data is coming in like this: Black, Black, Black, Yellow, Yellow, Green, Blue, Blue, Blue, Blue, Red, Red, Brown, Purple, Purple, Purple, Purple, Purple Can someone help with a Script or GREP that will remove the duplicates and leave me with this?: Black, Yellow, Green, Blue, Red, Brown, Purple Also, there are many more color combinations and the duplication can be up to 12 times in a string of text. Any help from the community is greatly appreciated!!
... View more