Add leading zeros if length = 4
I have a dataset something like this:
I want to add leading 0 if the length of data in column_1 is 4 and return in a new column. So that all data in the new column will be the length of 5.
Expected output:
Thank you.
I want to add leading 0 if the length of data in column_1 is 4 and return in a new column. So that all data in the new column will be the length of 5.
Expected output:
Thank you.
Find more posts tagged with
Sort by:
1 - 2 of
21
Hi @syazwaan,
A possible solution is work with a nominal data and logic if rule.
please find attached a simple sample.
Best
Hi!
If the data are numeric, you can use Format Numbers with a pattern of 00000. This will convert the numbers to a nominal column with the specified format that includes the leading zero if necessary. This would also work for smaller numbers.
Regards,
Balázs
If the data are numeric, you can use Format Numbers with a pattern of 00000. This will convert the numbers to a nominal column with the specified format that includes the leading zero if necessary. This would also work for smaller numbers.
Regards,
Balázs
Sort by:
1 - 1 of
11
Hi!
If the data are numeric, you can use Format Numbers with a pattern of 00000. This will convert the numbers to a nominal column with the specified format that includes the leading zero if necessary. This would also work for smaller numbers.
Regards,
Balázs
If the data are numeric, you can use Format Numbers with a pattern of 00000. This will convert the numbers to a nominal column with the specified format that includes the leading zero if necessary. This would also work for smaller numbers.
Regards,
Balázs