Alteryx Designer Desktop Discussions

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

Regex example

EN6924
10 - Fireball

I wanted to extract the amount info from the input -

EN6924_0-1647239519193.png

 

How can I achieve that adding applying a loop?

Note: Records having no amount will be blank in result as shown above.

 

Please help.

6 REPLIES 6
Qiu
21 - Polaris
21 - Polaris

@EN6924 
Can you give your expected output?
I am a bit confused.

EN6924
10 - Fireball

@Qiu 

Output has been already generated. The 'Amount' column is my output.

Wanted to know if this can be done in more short way.

Qiu
21 - Polaris
21 - Polaris

@EN6924 
Not really shorter. just made the regex shorter. 😁

Test23.PNG

EN6924
10 - Fireball

Great 😮 Thank you very much 😊

Qiu
21 - Polaris
21 - Polaris

@EN6924 
Glad to help and thank you for accepting my anwser. 😁

binuacs
21 - Polaris

@EN6924 another way using Regex Tokenize method

.*(\$\d+\W\w\S+)

binuacs_0-1647259806713.png

 

Labels
Top Solution Authors