Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Home
Discussions
Community Q&A

REPLACE Operator -

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

Accepted answers

All comments

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

Quick Links

All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)
Groups