9 Replies Latest reply: Nov 16, 2017 2:58 PM by Kailash Kotak RSS

    Replace function to insert "_" in data

    Kailash Kotak

      Hello,

       

      In my column (Unique identifier) I have data in this format 111122223333. I want to have data as 1111_2222_3333 format. This column has more that 150k records. How can i replace data from this format 111122223333 to 1111_2222_3333.

       

      Can I do this in my load script when i load the unique identifier column? Thank you in advance!

       

      Regards,

      Kailash