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.
Thank you!! However, some of the entries look like this "ABC92840" - with letters and numbers combined. Is there a way to find these values that have letters and number together so I can filter them out?
I have similar problem like i have some data where i want to have to find the fields which contain AB-1234567 and AB1234567 , the numbers can be anything from 0-9 but the format is as such as i mentioned , i tried regex match but its considering the entire filed if it matches only it is taking it but here i need to use contains any help?
The above solution helped me but i have negative values that i want also to return in addition to all positive real number from the filter formula REGEX_Match([Count], '^\d.*'), how do i include it on the custom formula of the filter?