Filter records - only field that contains numbers

[fiorano]

Hi,

I am looking to filter a recordset where a certain field must contain numbers.  If this field has  only letters then I would like to split these records out.

Many thanks,

Fiorano

[Thableaus · Accepted solution]

Hi @fiorano 

Filter tool - use this function in Custom Filter - REGEX_Match([Field], ".*\d+.*")

This will filter records with numbers in it.

The False side will be made of records with letters and punctuation only. 

Cheers,

[jeff_reynolds]

Something like the attached should do what you're looking for. I suck at RegEx, so I'm betting someone can it better, but this does work. 

There are two streams, both do the same thing, but you can watch what happens to the test data in either. 

Good luck. 

[fiorano]

Thank you!

[garretwalters12]

Why wouldnt  REGEX_Match("[^\d]") work? Isnt this saying any digit character not in the set? I was trying this before finding this article which works.