cancel
Showing results for 
Search instead for 
Did you mean: 

Internal : Unable to cast value '59,95 DH' to a number data item

Mohammed_AmineK
Level 2

Hi i try to write into collection  this value but they show me this message  : Internal : Unable to cast value '59,95 DH' to a number data item



------------------------------
Mohammed Amine KASSIMI
------------------------------
4 REPLIES 4

Hello, which call are you using could provide input details?
 
You need to normalize the data before performing the conversion, apparently the input format is incorrect.
Regards,


------------------------------
Leonardo Soares
RPA Developer Tech Leader
Bridge Consulting
América/Brazil
------------------------------
Leonardo Soares RPA Developer América/Brazil

33042.pngI get Data from a website using read stage and i try to store it into collection as numerci data 


------------------------------
Mohammed Amine KASSIMI
------------------------------

Hi Mohammed Amine Kassimi,

 For me it looks valid exception so   the data is "59.95 DH". Here "DH is not a number , so it is expected expectation, so in order to avoid this based on your requirment you can remove "DH" before converting to number.



------------------------------
-----------------------
If I answered your query. Please mark it as the "Best Answer"

Harish Mogulluri
Lead developer
America/New_York TX
------------------------------
-----------------------
If I answered your query. Please mark it as the Best Answer

Harish Mogulluri

Hello Mohammed,

You will need to clean non-numeric characters before inserting the data, if the character is always known use replace, you can also use regex to ensure that only the desired string in the desired format will be extracted.

Regards,



------------------------------
Leonardo Soares
RPA Developer Tech Leader
Bridge Consulting
América/Brazil
------------------------------
Leonardo Soares RPA Developer América/Brazil