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 am trying to figure out how i can filter a string column which only contains numbers. For example see below. How can use the filter tool to filter out everything and keep records 1&4? Bare in mind these are in the string data type.
The REGEX_Match function looks for pattern matches based on Regular Expressions. See https://regexr.com for more information on these, but in principal we're just using a specific set of commands to look for patterns in the string.
In my case the regex statement within the formula is
In \d+ \d represents any digit (0-9) and the + after it means ('one or more')
| represents an OR and means that the statement will also be true if the second part of the expression matches
\d+.\d+ is the same as the first part of the expression but adds in a decimal place