Add leading zeros if length = 4

User: "syazwaan"
syazwaan
New Altair Community Member
Updated by Jocelyn
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.

Find more posts tagged with

AI Studio
Generate Attributes
Sort by:
1 - 1 of 11
    User: "BalazsBaranyRM"
    BalazsBaranyRM
    New Altair Community Member
    Accepted Answer
    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
    View in context
Quick Links