This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a column that I would like to filter with a formula
I would like to get rid of the numbers (5476,6000) and be left with the letters and letter-number combinations.
I believe the regex formula would work best here, but I'm having trouble with the syntax.
how about using the IsNumber function?
In your example data there are some trailing spaces on the numbers, so I used the following filter :
This will filter any field which contains numbers followed by 0 or more spaces to the FALSE output
If you don't have trailing spaces in the fields in your actual data, this formula will also work:
all the data in the column is stored as a V_String. Would that cause the formula not to work?
The REGEX_Match formula should work for any string field (including V_STRING).
I believe ISNUMBER() has some challenges parsing cases like this, which is where REGEX may be helpful
I'm going to join in on the RegEx fun.
This will find TRUE any record that isn't just Numbers (with or without spaces).