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

    Replace function to insert "_" in data

    Kailash Kotak



      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!