How to filter only 5 & 6 digits value in a column

I have a column with 5 digits, 6 digits, 10 digits and 9 digits value.
I only need to filter the value with 5 & 6 digits.
I tried RegEx ribbon but if I say 5,6 in a column it trims of other values as well. I don't need that to happen.

Any help will be very helpful....

Thanks,

Regex

Accepted answers

mpennington

I'm not sure I follow exactly, but if you are wanting to keep only strings that are 5 or 6 digits long, you can filter with this formula:

REGEX_Match(ToString([Strings]), '^\d{5,6}$')

This result for TRUE node:

This for FALSE node:

All comments

mpennington

I'm not sure I follow exactly, but if you are wanting to keep only strings that are 5 or 6 digits long, you can filter with this formula:

REGEX_Match(ToString([Strings]), '^\d{5,6}$')

This result for TRUE node:

This for FALSE node:

Luke_C

Hi @vpalani08

Here's a non-regex approach. Depending on if your data is a string or numeric the 'tostring' piece may not be necessary.

Length(tostring([Field1])) in (5,6)

vpalani08

Thanks that works perfectly.

RRaoDannayak

Thank you for this solution I like it, however lets say if i want to filter the data that has 1,2,3,4 numbers in it like

111

1111

I tried using the formula and by adding additional required values but it didn't work as its only working for 2 values

REGEX_Match(ToString([ACCT-NBR]), '^\d{1,2,3,4}$')

Did i do anything wrong in the formula ??

Luke_C

Hi @RRaoDannayak

Change it to the below and it should work

REGEX_Match(ToString([ACCT-NBR]), '^\d{1,4}$')

RRaoDannayak

Hi @Luke_C Thanks for your reply, yup works like a champ

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703