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.
3 people like this idea
I meant … to have an option to convert a number including the comma. Jiri
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.
it was converting number to text, "When converting a number (e.g. 1000,50) to text the comma will disappear thus resulting in 100055" the converted text is without comma.
Have you used the "Replace Text" action in order to replace "," with "."? Having replaced it, then by using the "Convert Text to Number" action, the text will be converted to number, including the decimal digits.
I played a bit with replacing and converting and it looks fine. Thank you for help.
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
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?