topic Re: Problem with xml files in QlikView https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369364#M418708 <HTML><HEAD></HEAD><BODY><P>Can you provide more inputs that demonstrate the issue </P></BODY></HTML> Wed, 31 May 2017 16:00:07 GMT Anil_Babu_Samineni 2017-05-31T16:00:07Z Problem with xml files https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369363#M418707 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I have the problem that when I try to work on an XML file, I have things like</P><P>&lt;div&gt;, float;# and string;# before the actual data that I want to use.</P><P>Can I eliminate them in an easy way?</P><P></P><P>Purgechar and replace is not working properly...</P><P></P><P>regards,</P><P></P><P>Michael</P></BODY></HTML> Wed, 31 May 2017 15:58:08 GMT https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369363#M418707 2017-05-31T15:58:08Z Re: Problem with xml files https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369364#M418708 <HTML><HEAD></HEAD><BODY><P>Can you provide more inputs that demonstrate the issue </P></BODY></HTML> Wed, 31 May 2017 16:00:07 GMT https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369364#M418708 Anil_Babu_Samineni 2017-05-31T16:00:07Z Re: Problem with xml files https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369365#M418709 <HTML><HEAD></HEAD><BODY><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/165399_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>Like this. I just need the figures <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P></BODY></HTML> Wed, 31 May 2017 16:02:42 GMT https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369365#M418709 2017-05-31T16:02:42Z Re: Problem with xml files https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369366#M418710 <HTML><HEAD></HEAD><BODY><P>I always depends like below</P><P><STRONG>=Replace('float;#0.00000', 'float;#','')</STRONG></P></BODY></HTML> Wed, 31 May 2017 16:16:57 GMT https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369366#M418710 Anil_Babu_Samineni 2017-05-31T16:16:57Z Re: Problem with xml files https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369367#M418711 <HTML><HEAD></HEAD><BODY><P><STRONG><EM>=num(purgechar(lower(trim(FieldName)),'float;#'))</EM></STRONG></P></BODY></HTML> Wed, 31 May 2017 17:01:11 GMT https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369367#M418711 Kushal_Chawda 2017-05-31T17:01:11Z Re: Problem with xml files https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369368#M418712 <HTML><HEAD></HEAD><BODY><P>or</P><P></P><P><STRONG><EM>keepchar(FieldName,'0123456789')</EM></STRONG></P></BODY></HTML> Wed, 31 May 2017 17:02:49 GMT https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369368#M418712 Kushal_Chawda 2017-05-31T17:02:49Z Re: Problem with xml files https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369369#M418713 <HTML><HEAD></HEAD><BODY><P>Hello, Michael!</P><P></P><P>Replace will be the short solution:</P><P>Replace(TTM,'float;#','')</P><P><IMG alt="replace.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/165410_replace.png" style="height: auto;" /></P><P>PFA.</P></BODY></HTML> Wed, 31 May 2017 17:13:55 GMT https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369369#M418713 Sergey_Shuklin 2017-05-31T17:13:55Z Re: Problem with xml files https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369370#M418714 <HTML><HEAD></HEAD><BODY><P>sorry, all Solutions don't work...</P><P>I've attached the qvw, maybe it helps</P></BODY></HTML> Thu, 01 Jun 2017 06:41:59 GMT https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369370#M418714 2017-06-01T06:41:59Z Re: Problem with xml files https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369371#M418715 <HTML><HEAD></HEAD><BODY><P>Which Field we have to look? Is this related R&amp;D</P></BODY></HTML> Thu, 01 Jun 2017 06:44:50 GMT https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369371#M418715 Anil_Babu_Samineni 2017-06-01T06:44:50Z Re: Problem with xml files https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369372#M418716 <HTML><HEAD></HEAD><BODY><P>It's TTM for instance</P></BODY></HTML> Thu, 01 Jun 2017 06:51:34 GMT https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369372#M418716 2017-06-01T06:51:34Z Re: Problem with xml files https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369373#M418717 <HTML><HEAD></HEAD><BODY><P>This should work, Can you try from your end</P><P><STRONG>SubField(TTM,'#', -1)</STRONG></P></BODY></HTML> Thu, 01 Jun 2017 06:59:45 GMT https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369373#M418717 Anil_Babu_Samineni 2017-06-01T06:59:45Z Re: Problem with xml files https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369374#M418718 <HTML><HEAD></HEAD><BODY><P>It eliminates the float. Thank you.</P><P>But it does not Show the data as figures. We're halfway there <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P><P></P><P>--&gt;figures= number</P></BODY></HTML> Thu, 01 Jun 2017 07:05:03 GMT https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369374#M418718 2017-06-01T07:05:03Z Re: Problem with xml files https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369375#M418719 <HTML><HEAD></HEAD><BODY><P>Figures in the sense? Sorting you meant to say ?</P></BODY></HTML> Thu, 01 Jun 2017 07:08:20 GMT https://community.qlik.com/t5/QlikView/Problem-with-xml-files/m-p/1369375#M418719 Anil_Babu_Samineni 2017-06-01T07:08:20Z