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.
How to return only numbers using formula tool from a string that contains alphas, numbers and special characters also.
put this in the formula: REGEX_Replace([Field1], "[[:alpha:]]", "")
If there are some special characters in the set, just add | + "special character".
For example, if you want also to remove @: REGEX_Replace([Field1], "[[:alpha:]]|@", "")
as an alternative, you could use
were the \D is anything that is a non-digit. This would eliminate the need to specify non-alpha characters.
Thanks for the reply.I have used the Data Cleansing tool for the same.