https://community.blueprism.com/t5/University-Forum/Internal-Unable-to-cast-value-59-95-DH-to-a-number-data-item/m-p/87823#M1896 <P>Hi i try to write into collection&nbsp; this value but they show me this message&nbsp; : Internal : Unable to cast value '59,95 DH' to a number data item</P><BR /><BR />------------------------------<BR />Mohammed Amine KASSIMI<BR />------------------------------<BR /> Wed, 04 Oct 2023 13:59:00 GMT Mohammed_AmineK 2023-10-04T13:59:00Z https://community.blueprism.com/t5/University-Forum/Internal-Unable-to-cast-value-59-95-DH-to-a-number-data-item/m-p/87823#M1896 <P>Hi i try to write into collection&nbsp; this value but they show me this message&nbsp; : Internal : Unable to cast value '59,95 DH' to a number data item</P><BR /><BR />------------------------------<BR />Mohammed Amine KASSIMI<BR />------------------------------<BR /> Wed, 04 Oct 2023 13:59:00 GMT https://community.blueprism.com/t5/University-Forum/Internal-Unable-to-cast-value-59-95-DH-to-a-number-data-item/m-p/87823#M1896 Mohammed_AmineK 2023-10-04T13:59:00Z https://community.blueprism.com/t5/University-Forum/Internal-Unable-to-cast-value-59-95-DH-to-a-number-data-item/m-p/87824#M1897 <DIV><SPAN>Hello, which call are you using could provide input details?</SPAN></DIV> <DIV><SPAN>&nbsp;</SPAN></DIV> <DIV><SPAN>You need to normalize the data before performing the conversion, apparently the input format is incorrect.</SPAN></DIV> <DIV><SPAN></SPAN></DIV> <DIV><SPAN>Regards,</SPAN></DIV><BR /><BR />------------------------------<BR />Leonardo Soares<BR />RPA Developer Tech Leader<BR />Bridge Consulting<BR />América/Brazil<BR />------------------------------<BR /> Wed, 04 Oct 2023 14:52:00 GMT https://community.blueprism.com/t5/University-Forum/Internal-Unable-to-cast-value-59-95-DH-to-a-number-data-item/m-p/87824#M1897 LeonardoSQueiroz 2023-10-04T14:52:00Z https://community.blueprism.com/t5/University-Forum/Internal-Unable-to-cast-value-59-95-DH-to-a-number-data-item/m-p/87825#M1898 <DIV class="media" style="overflow: hidden; zoom: 1;"><span class="lia-inline-image-display-wrapper" image-alt="33042.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/33137i2A010167D9FD368D/image-size/large?v=v2&amp;px=999" role="button" title="33042.png" alt="33042.png" /></span>I get Data from a website using read stage and i try to store it into collection as numerci data&nbsp;</DIV><BR /><BR />------------------------------<BR />Mohammed Amine KASSIMI<BR />------------------------------<BR /> Wed, 04 Oct 2023 15:05:00 GMT https://community.blueprism.com/t5/University-Forum/Internal-Unable-to-cast-value-59-95-DH-to-a-number-data-item/m-p/87825#M1898 Mohammed_AmineK 2023-10-04T15:05:00Z https://community.blueprism.com/t5/University-Forum/Internal-Unable-to-cast-value-59-95-DH-to-a-number-data-item/m-p/87826#M1899 <P>Hi Mohammed Amine Kassimi,</P> <P></P> <P>&nbsp;For me it looks valid exception so&nbsp; &nbsp;the data is "<STRONG>59.95 DH</STRONG>". 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.</P> <P></P><BR /><BR />------------------------------<BR />-----------------------<BR />If I answered your query. Please mark it as the "Best Answer"<BR /><BR />Harish Mogulluri<BR />Lead developer<BR />America/New_York TX<BR />------------------------------<BR /> Wed, 04 Oct 2023 16:23:00 GMT https://community.blueprism.com/t5/University-Forum/Internal-Unable-to-cast-value-59-95-DH-to-a-number-data-item/m-p/87826#M1899 harish.mogulluri 2023-10-04T16:23:00Z https://community.blueprism.com/t5/University-Forum/Internal-Unable-to-cast-value-59-95-DH-to-a-number-data-item/m-p/87827#M1900 <P>Hello Mohammed,</P> <P>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.</P> <P>Regards,</P><BR /><BR />------------------------------<BR />Leonardo Soares<BR />RPA Developer Tech Leader<BR />Bridge Consulting<BR />América/Brazil<BR />------------------------------<BR /> Thu, 05 Oct 2023 04:06:00 GMT https://community.blueprism.com/t5/University-Forum/Internal-Unable-to-cast-value-59-95-DH-to-a-number-data-item/m-p/87827#M1900 LeonardoSQueiroz 2023-10-05T04:06:00Z