Answered

Trying to find only Alphabets with the result

(0) Share

Report

Posted on by mohan2mm

Hello,

I'm trying to get only USD from below value using Regex, I tried several ways "(?<=Total Amount Due: ).+" but unable to succeed, any help in this regards is appreciated.

Total Amount Due: 10,056.00 USDInvoice

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (1)

Sort by

eetuRobo 4,579 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Do you mean you only want the amount so the digits and not the text around it?
If so try this: ([\d.,]+)(?=\sUSDInvoice)
Result:

Or do you want to get the three letters USD?
Then try this: USD(?=Invoice)
Result:

If that doesn't work can you give example what should the outcome text be like?

Was this reply helpful? Yes No
mohan2mm 56 on at

Like
a
(0)

Report
Copy link

Link copied!

Below are the examples

1. Total Amount Due: 10,056.00 USDInvoice
2. Total Amount Due: 100,012.00 GBP
3. Total Amount Due: 1,056.00 EUR
4. Total Amount Due: 12,220,056.00 INRABC

I'm looking to get the currency from the above line items

Example 1 - USD
Example 2 - GBP
Example 3 - EUR
Example 4 - INR

Note - the currency characters would be only THREE characters in all the cases.

Was this reply helpful? Yes No
eetuRobo 4,579 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Try this: (?<=\d\s)\w{3}

Was this reply helpful? Yes No
mohan2mm 56 on at

Like
a
(0)

Report
Copy link

Link copied!

Could you please combine the Regex expression to derive only USD from below data.

Was this reply helpful? Yes No
eetuRobo 4,579 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Try this: (?<=Total Amount Due: [\d,.]+ )\w{3}

Was this reply helpful? Yes No
mohan2mm 56 on at

Like
a
(0)

Report
Copy link

Link copied!

This is awesome !! It started working.

Now, How can I get only the numerics?

Ex 1 - 10,056.00
Ex 2 - 100,012.00

Was this reply helpful? Yes No
Verified answer

eetuRobo 4,579 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

This should work I think:
(?<=Total Amount Due: )[\d,.]+

Was this reply helpful? Yes No