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 |
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?
User | Count |
---|---|
63 | |
24 | |
23 | |
21 | |
20 |