Set cell value in Excel includes hidden character

rpa
excel

#1

Hi
In my process I OCR a value from a PDF, trim whitespaces and then write that value via set cell into an Excel.
Problem is that in the resulting Excel this value includes some hidden leading character. That character makes it impossible to convert that value into number format.

If I write the same value into the same excel file via enter keystrokes-variable I can convert it perfectly into a number (via multiplication with 1)
So it seems like the set cell value operation adds some hidden character in front of the value.
Is that a known error?


If condition fails in comparsion
Using OCR result in an if-else condition
#2

It is not the Set Cell action, it is just junk symbol in result of OCR.

The Enter Keystrokes does not insert this symbol because it is non-printable (Bot cannot type it using keyboard)


#3

Excellent, thanks for the hint. Taking out the first character in the OCR result did the job.
:+1: