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:
Data | desired result |
12.3A736@ | 12.3736 |
2134.9A | 2134.9 |
789i/1 | 7891 |
122$#12 | 12212 |
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\.]", "")