2 Replies Latest reply: Apr 7, 2014 3:06 PM by julio césar torres RSS

    Parse/Convert text of Text Object into qvw Object data

    JASON SIGFRED SERIL

      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
          JASON SIGFRED SERIL

          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