1 Reply Latest reply: Mar 12, 2018 2:53 PM by Prashant Sangle RSS

    Search a parameter in a text file

    João Passos

      Hi,

       

       

       

      I have extracted a file from my system's configuration and I want to organize the configuration parameters in tabs.


      The main problem is: The file is organized from up to down, wich means that everything is going to be in a single tab "@1".

       

      I need to search the whole file to get the parameters I want. Here's an example:

       

      MODULE TAG="LIC-206A_1" PLANT_AREA="AREA_A/CALDEIRAS" CATEGORY=""

      user="ADMINISTRATOR" time=1164283218/* "23-Nov-2006 09:00:18" */

      {

        DESCRIPTION="Master PID control loop"

        PERIOD=5

        CONTROLLER=""

        PRIMARY_CONTROL_DISPLAY=""

        INSTRUMENT_AREA_DISPLAY="LOOP_FP"

        DETAIL_DISPLAY="LOOP_DT"

        TYPE="Analog Control"

        SUB_TYPE="CASCADE_MASTER"

        ASSIGN_BLOCKS_TO_H1_CARD=F

        FUNCTION_BLOCK NAME="AI1" DEFINITION="FFAI"

        {

        DESCRIPTION="Analog Input"

        ID=100376530

        RECTANGLE= { X=40 Y=180 H=56 W=140 }

      }
      }

       

       

       

      This above is a sample of an amount of 4k+ "tags".

       

      What I want to do is : The red ones turn into the title of the sheet and the green ones are going to be the items of the table.
      like this:

       

      Ex.jpg

       

       

      Is the Qlik Sense able to do what I need it for?

      If "yes", how can I do it?