DSXchange

Posted: **Thu Nov 29, 2007 12:29 am**

i have column contains data EX : "baby stroller baby toys blue stroller " from this i need to remove the word contains more than one time in this example "baby stroller " word are repeated i need to keep only first instance i need to populate out put as like " baby stroller toys blue " how i need to do this please any one can help in this

Posted: **Thu Nov 29, 2007 1:58 am**

Only with a custom routine or Build stage. The algorithm (psuedocode) would look something like:

Code: Select all

resultarray initialized to empty
foreach word in string
   if ! (word exists in resultarray)
      add word to resultarray
   endif
end foreach

DSXchange

Needs to remove duplicate words with in the column

Needs to remove duplicate words with in the column