6 Replies Latest reply: Dec 11, 2012 5:22 AM by Carlovski RSS

    Replace comma with || in a column

    Animesh Tripathi
      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