How to convert string to integer

(0) Share

Report

Posted on by lisa_garcia

Hi everyone,

I am using a AI model to extract information from an invoice document.

One of the extracted informations is the total value of the invoice, the extracted information as value is a total number, but the text result is the actual correct output since it´s providing the currency and the comma.

I now want to use the extracted text, convert it to int to use it in a condition to check, so if the amount is higher then 1000 a specific action has to happen.

Can anyone help me in setting up the correct flow?

Categories:

Using flows

I have the same question (0)

All responses (8)

Answers (1)

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @lisa_garcia ,

To convert currency string to number, you need below expression:

int(substring(outputs('Compose'),2,sub(length(outputs('Compose')),2)))

Best regards,

Was this reply helpful? Yes No
lisa_garcia 33 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-jefferni
I tried your solution but get another error:
the compose 2 looks like this:
int(substring(outputs('Verfassen'),2,sub(length(outputs('Verfassen')),2)))

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @lisa_garcia ,

So, the currency symbol is in the end. You can edit the expression as follow:

int(substring(outputs('Verfassen'),1,sub(length(outputs('Verfassen')),1)))

Best regards,

Was this reply helpful? Yes No
lisa_garcia 33 on at

Like (0)

Report
Copy link

Link copied!

hi @v-jefferni
It almost works but I´m missing a digit
Any idea?

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @lisa_garcia ,

Just need to extract substring from the first digit:

int(substring(outputs('Verfassen'),0,sub(length(outputs('Verfassen')),1)))

Best regards,

Was this reply helpful? Yes No
lisa_garcia 33 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-jefferni
thanks so much for helping me!
So I´m geeting a result, but still missing the two digits.. How do I get the number right?
Tried float but it isn´t working...

regards

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @lisa_garcia ,

Try below and you can get the currency:

formatNumber(float(substring(outputs('Compose'),0,sub(length(outputs('Compose')),1))),'$ #,###.00')

Best regards,

Was this reply helpful? Yes No
lisa_garcia 33 on at

Like (0)

Report
Copy link

Link copied!

Thanks so much @v-jefferni it worked!

Was this reply helpful? Yes No