topic Convert Values with different DecimalSep during LOAD in QlikView https://community.qlik.com/t5/QlikView/Convert-Values-with-different-DecimalSep-during-LOAD/m-p/150988#M28923 <HTML><HEAD></HEAD><BODY><P>Maybe this?</P><P style="padding-left:30px;">replace(MyNumber,',','.')</P></BODY></HTML> Sat, 08 Aug 2009 06:48:18 GMT johnw 2009-08-08T06:48:18Z Convert Values with different DecimalSep during LOAD https://community.qlik.com/t5/QlikView/Convert-Values-with-different-DecimalSep-during-LOAD/m-p/150986#M28921 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P></P><P>i need a solution for this problem. My script reads txt-files. In these files the data are tab seperated. Everything is fine so far, but there is one column in that file that has float values with both DecimalSep like "," and "."</P><P>Files that are older than 2007 have comma values and files that are newer use point values. I read the name of the file so i know from which date the values are (0901.txt [January 2009]). So i need to find a way to make a conversation during LOAD that converts all float values from comma to point value. I just want point values like 1.35</P><P>How can i do this!?</P><P>Thx in advance.</P><P>Greetings from Germany.</P><P>Frederik Nünning</P></BODY></HTML> Tue, 04 Aug 2009 17:23:31 GMT https://community.qlik.com/t5/QlikView/Convert-Values-with-different-DecimalSep-during-LOAD/m-p/150986#M28921 2009-08-04T17:23:31Z Convert Values with different DecimalSep during LOAD https://community.qlik.com/t5/QlikView/Convert-Values-with-different-DecimalSep-during-LOAD/m-p/150987#M28922 <HTML><HEAD></HEAD><BODY><P>Hi Frederik,</P><P>use the "num#" and "num" function.</P><P>The num# function evaluates the expression</P><P></P><H4>num#( expression [ , format-code [ , decimal-sep [ , thousands-sep ] ] ] )</H4><P>The num function formats the expression</P><P>num</P><H4>num( expression [ , format-code [ , decimal-sep [ , thousands-sep ] ] ] )</H4><P>Good luck!</P><P>Rainer</P><BR /><BR /> <BR /><BR /></BODY></HTML> Tue, 04 Aug 2009 17:53:22 GMT https://community.qlik.com/t5/QlikView/Convert-Values-with-different-DecimalSep-during-LOAD/m-p/150987#M28922 2009-08-04T17:53:22Z Convert Values with different DecimalSep during LOAD https://community.qlik.com/t5/QlikView/Convert-Values-with-different-DecimalSep-during-LOAD/m-p/150988#M28923 <HTML><HEAD></HEAD><BODY><P>Maybe this?</P><P style="padding-left:30px;">replace(MyNumber,',','.')</P></BODY></HTML> Sat, 08 Aug 2009 06:48:18 GMT https://community.qlik.com/t5/QlikView/Convert-Values-with-different-DecimalSep-during-LOAD/m-p/150988#M28923 johnw 2009-08-08T06:48:18Z