Filtering by number of digits in a specific field

[hovicke]

Hi - I have a large data file that has different product information in it. One of the columns has some description text as well as a number embedded somewhere in the description. I want to filter out the rows that contain only a 4 digit number in the description, nothing more or less than 4 digits. 

For example: Below is an example of the column of text/number. I want only the first the third rows because the number is 4 digits.

This product is low - 0832. Status is pending.

This product is medium - 034572. Status is good.

This product is high - 0447. Status is confirmed.

This product is none - 032. Status is pending.

Is this possible with the filter tool? I hope this makes sense.

[PhilipMannering]

Hey @hovicke 

You can use this regex expression in a Filter Tool,

NOT REGEX_Match([Text], '.*\b\d{4}\b.*')

[NMangera]

Hi @hovicke 

For your convenience. This is what the workflow looks like.

[PhilipMannering]

Rereading your question, if you want to keep the ones with 4 digits, just remove the `not` at the start of the expression. Same difference, just switches the True and False.