🎉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

REPLACE Operator -

User: "RMforDUMMIES"
RMforDUMMIES
New Altair Community Member
Updated by Jocelyn
I have a column of zip codes. Some zip codes have letters instead of numbers in the last two or three placeholders. I am using the REPLACE operator, selecting [A-Z] replace with 0 (zero). When I run this, I do not see zeros. The letters are gone but any placeholders at the end of the 5 digit zip codes are now blank, instead of zero.  - Sincerely, RMforDummies

Find more posts tagged with

AI Studio
Sort by:
1 - 2 of 21
    User: "varunm1"
    varunm1
    New Altair Community Member
    Hello @RMforDUMMIES

    Can you provide your sample data? It is working fine for me.

    Thanks
    User: "BalazsBaranyRM"
    BalazsBaranyRM
    New Altair Community Member
    Did you enter the 0 only in the Regular Expressions testing window? It has to be in the operator parameters. Your problem sounds like an empty replacement parameter in the operator.

    Regards,
    Balázs
Quick Links