This discussion is archived
6 Replies Latest reply: Dec 11, 2012 3:22 AM by Carlovski RSS

Replace comma with || in a column

AnimeshTripathi Newbie
Currently Being Moderated
Hi All,

My Requirement is like this:
In a column i need to replace every third comma(,) with || symbol.
 
eg:
1,Animesh,1234,2,Tripathi,4321,3,Oracle,2345.....(and so on)
 
Desired output:
1,Animesh,1234||2,Tripathi,4321||3,Oracle,2345....
Please help me out.
-
Regards
Animesh

Legend

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