https://community.qlik.com/t5/Data-Quality/Convert-object-money-datatype-to-double/m-p/2283776#M3877 <P>What is the best way to convert an object "money" to double?</P> <P>&nbsp;</P> <P>The current structure of the object is (ie. 2,709.00) where double doesn't accept the "comma" value. I tried using the tConvertType (to convert object to double) but I am not sure how to parse the "comma" from there. I also tried parsing it from tMap and it's not working as it's looking for a "string" and not a double.</P> <P>&nbsp;</P> Sat, 16 Nov 2024 08:49:46 GMT Anonymous 2024-11-16T08:49:46Z https://community.qlik.com/t5/Data-Quality/Convert-object-money-datatype-to-double/m-p/2283776#M3877 <P>What is the best way to convert an object "money" to double?</P> <P>&nbsp;</P> <P>The current structure of the object is (ie. 2,709.00) where double doesn't accept the "comma" value. I tried using the tConvertType (to convert object to double) but I am not sure how to parse the "comma" from there. I also tried parsing it from tMap and it's not working as it's looking for a "string" and not a double.</P> <P>&nbsp;</P> Sat, 16 Nov 2024 08:49:46 GMT https://community.qlik.com/t5/Data-Quality/Convert-object-money-datatype-to-double/m-p/2283776#M3877 Anonymous 2024-11-16T08:49:46Z https://community.qlik.com/t5/Data-Quality/Convert-object-money-datatype-to-double/m-p/2283777#M3878 <P><FONT face="lucida sans unicode,lucida sans">You may be able to try the following way at tMap:</FONT></P> <P><FONT face="lucida sans unicode,lucida sans">Double.parseDouble((String.valueOf(row8.money)).replace(",", ""))&nbsp;</FONT></P> <P><FONT face="lucida sans unicode,lucida sans">I hope it'll help you.</FONT></P> Mon, 22 Jan 2018 09:48:44 GMT https://community.qlik.com/t5/Data-Quality/Convert-object-money-datatype-to-double/m-p/2283777#M3878 Anonymous 2018-01-22T09:48:44Z