This discussion is archived
1 Reply Latest reply: Jan 11, 2013 1:42 AM by anders northeved - oracle RSS

more Replace needed inside a single cell , more than 2-3

984061 Newbie
Currently Being Moderated
in a single cell on there are values like

6602,6602,6594,7970
7970;6602;6602;
6591,6591;,,7346,6591;,,7346

now these values are inside a single cell

now i want to remove the duplicates

like in the first row the out put should be
6602,6594,7970
second row output should be
7960,6602
third row
6591,7346

please help
:'(

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points