🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Add leading Zeros

User: "xDSticker"
xDSticker
New Altair Community Member
Updated by Jocelyn
Dear Dataminers,

I try to add leading zeros to the numbers within an attribut. Is there any way to do so?

I tried to find a regualr expression but couldn't find a solution :(

Thank you for your time
Sticker

Find more posts tagged with

AI Studio
Sort by:
1 - 1 of 11
    User: "MariusHelf"
    MariusHelf
    New Altair Community Member
    It's not thaaat easy, but it is possible. First of all, you have to convert the numerical attribute into a nominal attribute with Numerical to Polynominal. Then you have to create several regular expressions. For 3-digit values in the form:

    ^(\d)$ -> 00$1
    ^(\d\d)$ -> 0$1

    The caret specifies that the expression must be matched at the beginning of the string, the dollar stands for the end of the string. Both together require an exact match.

    Best regards,
    Marius
Quick Links