0 votes

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)
by
edited by

1 Answer

+2 votes
Best answer

Hi,

Use a formula. If your column is called stuff and you want 11 chars in the output, use:

format("%011d", stuff)

More info about the format function here: http://answers.dataiku.com/767/how-to-remove-scientific-notation-in-a-column
by
selected by
It almost works, but not quite : format("%011d", stuff) worked. Thanks
Thanks, edited!
1,213 questions
1,246 answers
1,407 comments
11,779 users

©Dataiku 2012-2018 - Privacy Policy