topic Parse/Convert text of Text Object into qvw Object data in QlikView

Parse/Convert text of Text Object into qvw Object data

jasonseril — Thu, 11 Mar 2010 09:18:56 GMT

Hello all,

I would like to know if there's available macro that converts/parses text from Qlikview Text Object into object (table, charts..) data?

thanks in advance. cheers.

jason

Parse/Convert text of Text Object into qvw Object data

jasonseril — Fri, 12 Mar 2010 07:07:42 GMT

another inquiry, can we use regex to parse XML-format text and get the data? Below is the example XML-format text:

<Forecast>
 <Date>2010-03-12T00:00:00</Date>
 <WeatherID>4</WeatherID>
 <Desciption>Sunny</Desciption>
 <Temperatures>
 <MorningLow>22</MorningLow>
 <DaytimeHigh>50</DaytimeHigh>
 </Temperatures>
 <ProbabilityOfPrecipiation>
 <Nighttime>00</Nighttime>
 <Daytime>00</Daytime>
 </ProbabilityOfPrecipiation>
 </Forecast>2054120

if so, really appreciate if somebody could provide an example or the regex pattern for the above text. Thanks

jason

Re: Parse/Convert text of Text Object into qvw Object data

Mon, 07 Apr 2014 19:02:10 GMT

holaaaa!! ME podrían decir como convierto archivos de XML a QVW??, no se si en qlikview tenga la opción y con alguna otra herramienta para importar los archivos de xml a qlikview

hi! ME could say as I convert XML files to qvw?, Not if you have the option in qlikview and some other tool to import xml files to qlikview