Start Free Trial

Alteryx Designer Desktop Discussions

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

Fetching a series of numerical values with spaces in between.

Grail030510
8 - Asteroid

Good day everyone,

 

Is there a way to use parse method only on the given example below?

 

Thank You in Advance.

 

Given:

 

Student No: 123  245  788 3456 here

 

OUTPUT:

 

1232457883456

2 REPLIES 2
flying008
15 - Aurora

Hi, @Grail030510 

 

You can use the formula:

 

RegEx_Replace([Txt], '\D', '')

 

Grail030510
8 - Asteroid

Works Great @flying008 , Thank you so much

Labels
Top Solution Authors