Filter line which contain 10 digits

Question

Hello - I have a data set where I am looking to filter out all line which are not 10 digits.

See example data attached.

After the filter I want to be left only with those lines which contained exactly 10 digits in the 'code' column, removed any which are above or below 10.

Thanks

Filter only lines which are 10 digits.xlsx

philipmannering · Accepted Answer

in the filter tool you can use the expression,

regex_match(tostring(Code), '\d{10}')

Hope this helps!

atcodedog05 · Accepted Answer

Hi @tom05

Here is a workflow for the task.

Filter

Length(ToString([Code]))>=10

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍