Support Portal

for ProcessRobot and WinAutomation

Start a new topic

Converting number/text

When converting a number (e.g. 1000,50) to text the comma will disappear thus resulting in 100055. Would it be possible to have an option to convert including the comma?

Besides, if the number is with dot (e.g. 1.000,55) an error occurs. This can of course be bypassed by "replace text", but maybe an option in the converter could minimize the steps/actions needed.


Best regards,

Nicolai


2 people like this idea

It would be helpful, actually I do not understand why it does not work this way. Thank you for considering this. Or is there some simple way or configuration to make it working this way? Thank you. Jiri

ADMIN

Hello Nicolai,


Thank you for your feedback.


Please note that we have forwarded your suggestion to the appropriate department and it will be taken into consideration for future releases of our Software.


Jiri, could you please elaborate on which of the above you are trying to find a workaround?

Hello Georgia,

I meant … to have an option to convert a number including the comma. Jiri

ADMIN

Hello Jiří,


In case you extract information from a website or an excel file etc. the type of variable will be Text Value. You can use the "Replace Text" action in order to replace "," with ".". Then, by using the "Convert Text to Number" action, the text will be converted to number, including the decimal digits. 


Login or Signup to post a comment