Free Trial

Alteryx Designer Desktop Discussions

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

How can I extract the numbers after a certain word

Sshasnk
8 - Asteroid

I have a list of string, where I have to fetch numbers from. The number will be there after a word Num

 

Example:

Input:

String
\abc_Apple\Num1234\fruit123.xlsx
\ac_Appl\Num124\fruit123.xlsx
\abcd_Appl\Num134\fruit123.xlsx
\abced_Apple\12Num1234\fruit123.xlsx

 

Output:

Value
1234
124
134
1234
1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@Sshasnk 
We can use RegEx

0109-Sshasnk.png

Labels
Top Solution Authors