Hello, friends, I have data that should be only numbered but due to mistakes, it contains now symbols or letters.
but keep the decimal. anyhelp?
example:
Hi @MZ900605
Use regex formula like below
REGEX_Replace([Data], "[^\d.]+", "")
Workflow:
Hope this helps : )
Maybe a formula like this?
REGEX_Replace([Data], "[^0-9\.]", "")