Add undefinite number of characters to strings

Options
bored_panda
bored_panda Registered Posts: 11 ✭✭✭✭
edited July 16 in Using Dataiku

I have a string column with a number of chars in it that can be up to 10, I need to fill the beginning of each cell with "0"s so that each cell is 10 chars. So, for instance, transform this


12345
3948
36
1234567890
48975646



Into :


0000012345
0000003948
0000000036
1234567890
0048975646

How can I do that ? (Can't use SQL)

Best Answer

Answers

Setup Info
    Tags
      Help me…