I have a column of data that contains numbers, text, etc.. However, I want to filter out any records with text. What is the best way to do that?
Take a look at the sample workflow attached with the filter configured - it should remove the data for you.
Parse it to a new column using (\w+) and then filter on the new column with !isnull(new field)
Regex_match([field],"[\u\l\s]+")
letters and space only
cheers,
mark
Drop a filter tool onto the canvas, select "custom", and enter the following expression: !REGEX_Match([Field_Name], ".*[[:alpha:]].*").
Make sure to replace the [Field_Name] placeholder with the actual field name.
This works great, however, I noticed some of the data also has text after a number. Ex 1234_DOT and 1234DOT. How would I capture these conditions?
