https://community.qlik.com/t5/App-Development/convert-text-to-money-in-load-script/m-p/2415310#M95044 <P>Just keeping the relevant information might be done per:</P> <P>keepchar(MyField, '0123456789,') as MyField</P> Tue, 06 Feb 2024 09:37:32 GMT marcus_sommer 2024-02-06T09:37:32Z https://community.qlik.com/t5/App-Development/convert-text-to-money-in-load-script/m-p/2415037#M95017 <P>Hi expert,&nbsp;</P> <P>i am having trouble managing a format conversion</P> <P>I have a field like this</P> <P>€ 11.100,32</P> <P>qlik import as text, and i can't use it to sum <span class="lia-unicode-emoji" title=":confused_face:">😕</span></P> <P>How I import in load script as money ( euro) or num in order to use it to sum?&nbsp;</P> <P>Thanks in advance</P> <P>D.</P> <P>&nbsp;</P> Mon, 05 Feb 2024 20:04:09 GMT https://community.qlik.com/t5/App-Development/convert-text-to-money-in-load-script/m-p/2415037#M95017 die77 2024-02-05T20:04:09Z https://community.qlik.com/t5/App-Development/convert-text-to-money-in-load-script/m-p/2415164#M95033 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/259107">@die77</a>&nbsp;you can use format around like&nbsp;<A href="https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/Scripting/FormattingFunctions/Money.htm" target="_blank">Money - script and chart function | QlikView Help</A></P> Tue, 06 Feb 2024 05:55:11 GMT https://community.qlik.com/t5/App-Development/convert-text-to-money-in-load-script/m-p/2415164#M95033 Anil_Babu_Samineni 2024-02-06T05:55:11Z https://community.qlik.com/t5/App-Development/convert-text-to-money-in-load-script/m-p/2415310#M95044 <P>Just keeping the relevant information might be done per:</P> <P>keepchar(MyField, '0123456789,') as MyField</P> Tue, 06 Feb 2024 09:37:32 GMT https://community.qlik.com/t5/App-Development/convert-text-to-money-in-load-script/m-p/2415310#M95044 marcus_sommer 2024-02-06T09:37:32Z https://community.qlik.com/t5/App-Development/convert-text-to-money-in-load-script/m-p/2415318#M95045 <P>Hi</P> <P>Try like below</P> <P>Money(Money#(Replace('€ 11.100,32','€ ',''), '##.###,##',',','.'))</P> Tue, 06 Feb 2024 09:53:06 GMT https://community.qlik.com/t5/App-Development/convert-text-to-money-in-load-script/m-p/2415318#M95045 MayilVahanan 2024-02-06T09:53:06Z