In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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