We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Keep numeric data

MZ900605
8 - Asteroid

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:

Datadesired result
12.3A736@12.3736
2134.9A2134.9
789i/17891
122$#1212212
2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

Hi @MZ900605 

 

Use regex formula like below

REGEX_Replace([Data], "[^\d.]+", "")

 

Workflow:

atcodedog05_0-1641491720849.png

 

Hope this helps : )

 

BrandonB
Alteryx
Alteryx

Maybe a formula like this?

 

REGEX_Replace([Data], "[^0-9\.]", "")

Labels