REPLACE Operator -

RMforDUMMIES

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

varunm1

Hello @RMforDUMMIES

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

Thanks

BalazsBaranyRM

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