Free Trial

Alteryx Designer Desktop Discussions

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

cleansing

rag329
8 - Asteroid

hi team. how to remove these characters and just filter out the numbers in this words. please help me. thanks in advance. 

 

column 1     Column 2

12 new         Â£2.50

8 new           Â£5

45 Â new        Â£ 12.2

 new 85        10£ 

 

output

 

column 1     Column 2

12                 2.50

8                   5

45                12.2

85                 10

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@rag329 
I replace the alphabet and speciall character with RegEx

I hope there is other better way.

0822-rag329.PNG

 

rag329
8 - Asteroid

thank you so much @Qiu 

Labels
Top Solution Authors