Regex

Hi,

I have a zipcode field in a dataset and which might not include digits and have state codes. I need to check to see if it contains numbers or not and filter out the records that doesn't contain digits. I tried regex but didn't get the expected output and getting some data type mismatch error. Looking for some help. Thanks in advance!

Output

Accepted answers

binu_acs

@aparna0208 Let me know if the below filter condition works for you

Filter_Non_Numeric_230523.yxmd

All comments

dsandmann

REGEX_Match([Field], '[0-9]{5}')

That formula will check to see if there are 5 digits in a row within a the field, you can use it inside a filter tool. Without more details around your data examples it will be challenging to diagnose further.

aparna0208

@dsandmann Thanks for the inputs. I already tried this and also the same formula with 'd' instead of 0-9 but the problem is I'm getting data type error "tried to apply string operator to numeric value" even after using select tool to change data type to double

BRRLL99

Do you have any sample input with expected output.

for Regex formula to work we need to understand the logic for the data

binu_acs

@aparna0208 Let me know if the below filter condition works for you

Filter_Non_Numeric_230523.yxmd

aparna0208

@binu_acs Got busy with something and got back on this today and it worked:) Thank you so much!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703