topic Re: How to separate the XML data in particular field in QlikView https://community.qlik.com/t5/QlikView/How-to-separate-the-XML-data-in-particular-field/m-p/681160#M1068326 <HTML><HEAD></HEAD><BODY><P>Perhaps you can use the FROM_FIELD load option. See this discussion: <A href="https://community.qlik.com/message/536268">Re: Re: How to extract data from xml stored in a database</A>. If you don't manage to get that working you may have to use the textbetween() function. See <A href="https://community.qlik.com/message/166059">xml data handling with from_field</A></P></BODY></HTML> Mon, 01 Sep 2014 11:22:36 GMT Gysbert_Wassenaar 2014-09-01T11:22:36Z How to separate the XML data in particular field https://community.qlik.com/t5/QlikView/How-to-separate-the-XML-data-in-particular-field/m-p/681159#M1068325 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>&nbsp; I have field called&nbsp; Information in the database and in that field the XML Data are load, Now i want to separate&nbsp; the XML data in the field information.</P><P></P><P>EX&nbsp; XML Data: name ; address, city, state in the Field (Information) in the&nbsp; database. can nay one help on this.</P><P></P><P>Thanks &amp; regards,</P><P>Sivakumar</P></BODY></HTML> Mon, 01 Sep 2014 11:17:11 GMT https://community.qlik.com/t5/QlikView/How-to-separate-the-XML-data-in-particular-field/m-p/681159#M1068325 Anonymous 2014-09-01T11:17:11Z Re: How to separate the XML data in particular field https://community.qlik.com/t5/QlikView/How-to-separate-the-XML-data-in-particular-field/m-p/681160#M1068326 <HTML><HEAD></HEAD><BODY><P>Perhaps you can use the FROM_FIELD load option. See this discussion: <A href="https://community.qlik.com/message/536268">Re: Re: How to extract data from xml stored in a database</A>. If you don't manage to get that working you may have to use the textbetween() function. See <A href="https://community.qlik.com/message/166059">xml data handling with from_field</A></P></BODY></HTML> Mon, 01 Sep 2014 11:22:36 GMT https://community.qlik.com/t5/QlikView/How-to-separate-the-XML-data-in-particular-field/m-p/681160#M1068326 Gysbert_Wassenaar 2014-09-01T11:22:36Z Re: How to separate the XML data in particular field https://community.qlik.com/t5/QlikView/How-to-separate-the-XML-data-in-particular-field/m-p/681161#M1068327 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>have a look at attached application.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Mon, 01 Sep 2014 11:36:39 GMT https://community.qlik.com/t5/QlikView/How-to-separate-the-XML-data-in-particular-field/m-p/681161#M1068327 ashfaq_haseeb 2014-09-01T11:36:39Z