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

[Mohammed_AmineK]

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
------------------------------

[LeonardoSQueiroz]

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
------------------------------

[Mohammed_AmineK]

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

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

[harish.mogulluri]

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
------------------------------

[LeonardoSQueiroz]

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
------------------------------