Unanswered

Numeric Value is being detected as text

(0) Share

Report

Posted on by kbachani

So I am using the Extract Text with OCR as I have to grab data from a virtual machine. The problem is that it can grab the data just fine once I tweak it but afterwards the numeric data is being read as text.

This is the text value of the variable and it is being read correctly. I want to convert this value into another variable by multiplying it by 1.3.

This is the function I used and this is the error I received.

I wanted to check what type of text it was reading so I ran this through a recognize entities in text function and it gave out this value.

Instead of one value of 5.78, it gives 2 values of 5 and 78.

I want to make it one value.

The problem is this happens only sometimes with certain numbers, other numbers are instantly detected as one value even with a decimal point.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sundeep_Malik 6,484 on at

Like (0)

Report

Hey @kbachani
Try using text to integer action. Might help you.

https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Reading-numbers-from-a-web-page/td-p/1295022

https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Convert-text-to-integer-in-PAD/td-p/752466

Was this reply helpful? Yes No
kbachani 11 on at

Like (0)

Report

I have tried it before and it doesn't seem to work. This is the error I get.

I just tried setting the variable into my clipboard and this is what comes out 5.78 I have to find a way to remove that unrecognisable character.

Was this reply helpful? Yes No
Verified answer

kbachani 11 on at

Like (0)

Report

Hey so after a lot of trial and error I found the problem. If anyone has invisible characters in their text this may be due to the replacement function. My data would sometimes be read with a space in between the numbers so I added a replace function where it would replace \s with \b but this led to power automate to create an invisible character to remove the space. I eventually figured it out and changed it to replace %' '% with %''% and that removed the spaces without adding the invisible character.

Was this reply helpful? Yes No