Needs to remove duplicate words with in the column

[uppalapati2003]

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

[ray.wurlod]

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