In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
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