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
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,
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.
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.
