REPLACE Operator -

RMforDUMMIES
RMforDUMMIES New Altair Community Member
edited November 2024 in Community Q&A
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
Tagged:

Answers

  • varunm1
    varunm1 New Altair Community Member
    Hello @RMforDUMMIES

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

    Thanks
  • 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

Categories