Answered

Extract Dollar Amount from String, but skip first fullstop

(0) Share

Report

Posted on by LW-28112008-0

I have the following snippit from a GMAIL get email activity

"This month your services come to $94.07. This amount is due on 21 Sep 2021. Spark logo Account # 123456789 $94.07 to pay by 21 Sep 2021 $94.07 to pay by 21 Sep 2021 Pay Online If you have a direct"

I would like to extract the $ amount of the bill.

I followed some online tutorials, but getting stuck at skipping the first fullstop in the middle of the dollar amount.

Any ideas please?

All responses (6)

Answers (1)

v-bofeng-msft on at

Like (0)

Report

Re: Extract Dollar Amount from String, but skip first fullstop

Hi @LukePWilkins :

Hope this link helps:

Reference guide to using functions in expressions for Azure Logic Apps and Power Automate

Best Regards,
Bof
LW-28112008-0 on at

Like (0)

Report

Re: Extract Dollar Amount from String, but skip first fullstop

hey there @v-bofeng-msft , that is awesome! How do you learn this stuff? To come up with that formula.
Thanks for the help, that is ace.
Verified answer

v-bofeng-msft on at

Like (0)

Report
Re: Extract Dollar Amount from String, but skip first fullstop

Hi @LukePWilkins :

Please try:

The formula:

concat('$', if( endsWith(split(split(outputs('Compose'),'$')[1],' ')[0],'.'), take(split(split(outputs('Compose'),'$')[1],' ')[0],sub(length(split(split(outputs('Compose'),'$')[1],' ')[0]),1)), split(split(outputs('Compose'),'$')[1],' ')[0] ) )

Result:

Best Regards,

Bof
LW-28112008-0 on at

Like (0)

Report

Re: Extract Dollar Amount from String, but skip first fullstop

Thank you for the tip, I see that would work well.
I was hoping for a process that used the native functionality of MS Flow, rather than tap into a 3rd party API.

Cheers for posting, it will help other people in the community
v-bofeng-msft on at

Like (0)

Report
Re: Extract Dollar Amount from String, but skip first fullstop

Hi @LukePWilkins :
Do you want to get the amount in this string

This month your services come to $94.07. This amount is due on 21 Sep 2021. Spark logo Account # 123456789 $94.07 to pay by 21 Sep 2021 $94.07 to pay by 21 Sep 2021 Pay Online If you have a direct

If so,I've made a test for your reference:

Result:

In addition, Plumsail Documents is a fee-based third-party service but you can apply for a one-month free license.

Best Regards,

bof
v-bofeng-msft on at

Like (0)

Report
Re: Extract Dollar Amount from String, but skip first fullstop

Hi @LukePWilkins :
Do you want to get the amount in this string

This month your services come to $94.07. This amount is due on 21 Sep 2021. Spark logo Account # 123456789 $94.07 to pay by 21 Sep 2021 $94.07 to pay by 21 Sep 2021 Pay Online If you have a direct

If so,I've made a test for your reference:

Result:

In addition, Plumsail Documents is a fee-based third-party service but you can apply for a one-month free license.

Best Regards,

bof