We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to extract specific amount from row with multiple number sets

PDempsey
7 - Meteor

Hello,

 

I need to extract the amount 32,765.00 from the string below.

Sometimes it will be preceded by EUR, other times USD etc.

I tried using Regex but it only extracted the "121212121" at the end of the text.

Appreciate any help, thanks in advance.

 

Convert Please Pay EUR 32,765.00  Inv No: DCB121212121
10 REPLIES 10
PDempsey
7 - Meteor

This really helped, thank you. However, it only picks up amounts with comma's in them, i.e. it does not pick up amounts less than 1,000 is there a way to also have it pick up amounts les sthan 1,000 please?

Labels
Top Solution Authors