Deleting leading zeros
I want to remove the leading Zeros from the Customer ID and while transferring the values in BPC, I want to prefix the value (after removing the zeros) with 'CC_'. eg: 000012345 so I want to transfer that as 'C_12345'.
In transformation file, I had done the mapping as
which works fine, if I dont have to remove the zeros but i want to remove zeros and concatenate "CC_"
Thanks in advance