4 Replies Latest reply on Mar 6, 2017 6:09 AM by shashank.sastry

    regex help for particular db field(text and numeric values together)

    shashank.sastry

      Hi,

       

      I have following requirements.

      I have a field which contains both text and numeric values.

       

      my fields are like this

       

       

      ID

      change1[c1,c2,c3]

      change2[c2,c3]

      change3[c3,c4]

       

       

      I need to split this columns like this

       

      comments   ID

      change1      c1,c2,c3

      change2      c2,c3

      change3       c3,c4