selection of context in files

manas_ranjan · December 9, 2008, 9:36am

I have a file like this

                                       QUEUE: &lt;ITEM\(69\)&gt;      "/NLA///ACHO\_EQU_IDX"
                                       Q_KEY: &lt;ITEM\(69\)&gt;      "/NLA///ACHO\_EQU_IDX"
                                      Q_TYPE: &lt;VSTR\(32\)&gt;      "GEN\_VSTR_INDEX"
                                   QOBJ_TYPE: &lt;VSTR\(32\)&gt;      "MSG\_HISTORY_SEQ"
                                    Q_DOMAIN: &lt;VSTR\(7\)&gt;       "MESSAGE"
                                DUP\_KEY_FLAG: &lt;STR\(1\)&gt;        "Y"
                               PERIODIC_FLAG: &lt;STR\(1\)&gt;        "N"
                                    UNION_ID: &lt;BITS\(8\)X&gt;      "00000000"
                                  USED_BYTES: &lt;LONG\(10\)X&gt;     "0"
                             ALLOCATED_BYTES: &lt;LONG\(10\)X&gt;     "0"

                                    QELEMENT: &lt;LONG\(10\)&gt;      "1"
                                 QELEMENT_ID: &lt;LONG\(10\)S&gt;     "1"
                              QELEMENT_STATE: &lt;VSTR\(132\)S&gt;    "JOIN"
                     VSTR\_KEY$GEN\_VSTR_INDEX: &lt;VSTR\(80\)S&gt;     "EQUENS0002C081119081119081119"
                      SYSTIME$GEN\_VSTR_INDEX: &lt;TIME\(23\)S&gt;     "19-NOV-2008 20:55:34.38"
                          TXT$GEN\_VSTR_INDEX: &lt;VSTR\(20\)S&gt;     "2008111900000218"
                         HISTORY_COORDINATES: &lt;HST_ID\(23\)S&gt;   "2/3"
                                  MESSAGE_ID: &lt;MSG_ID\(17\)S&gt;   "20081119/00000218"
                                         END: &lt;VSTR\(48\)&gt;      "QELEMENT"

                                    QELEMENT: &lt;LONG\(10\)&gt;      "2"
                                 QELEMENT_ID: &lt;LONG\(10\)S&gt;     "2"
                              QELEMENT_STATE: &lt;VSTR\(132\)S&gt;    "JOIN"
                     VSTR\_KEY$GEN\_VSTR_INDEX: &lt;VSTR\(80\)S&gt;     "EQUENS0002C081124081124081124"
                      SYSTIME$GEN\_VSTR_INDEX: &lt;TIME\(23\)S&gt;     "24-NOV-2008 12:51:51.83"
                          TXT$GEN\_VSTR_INDEX: &lt;VSTR\(20\)S&gt;     "2008112400000058"
                         HISTORY_COORDINATES: &lt;HST_ID\(23\)S&gt;   "2/3"
                                  MESSAGE_ID: &lt;MSG_ID\(17\)S&gt;   "20081124/00000058"
                                         END: &lt;VSTR\(48\)&gt;      "QELEMENT"

                                    QELEMENT: &lt;LONG\(10\)&gt;      "3"
                                 QELEMENT_ID: &lt;LONG\(10\)S&gt;     "3"
                              QELEMENT_STATE: &lt;VSTR\(132\)S&gt;    "JOIN"
                     VSTR\_KEY$GEN\_VSTR_INDEX: &lt;VSTR\(80\)S&gt;     "EQUENS1100C081119081119081119"
                      SYSTIME$GEN\_VSTR_INDEX: &lt;TIME\(23\)S&gt;     "19-NOV-2008 20:54:15.93"
                          TXT$GEN\_VSTR_INDEX: &lt;VSTR\(20\)S&gt;     "2008111900000214"
                         HISTORY_COORDINATES: &lt;HST_ID\(23\)S&gt;   "2/3"
                                  MESSAGE_ID: &lt;MSG_ID\(17\)S&gt;   "20081119/00000214"
                                         END: &lt;VSTR\(48\)&gt;      "QELEMENT"

                                    QELEMENT: &lt;LONG\(10\)&gt;      "4"
                                 QELEMENT_ID: &lt;LONG\(10\)S&gt;     "4"
                              QELEMENT_STATE: &lt;VSTR\(132\)S&gt;    "JOIN"
                     VSTR\_KEY$GEN\_VSTR_INDEX: &lt;VSTR\(80\)S&gt;     "EQUENS1100C081124081124081124"
                      SYSTIME$GEN\_VSTR_INDEX: &lt;TIME\(23\)S&gt;     "24-NOV-2008 11:15:48.27"
                          TXT$GEN\_VSTR_INDEX: &lt;VSTR\(20\)S&gt;     "2008112400000008"
                         HISTORY_COORDINATES: &lt;HST_ID\(23\)S&gt;   "2/3"
                                  MESSAGE_ID: &lt;MSG_ID\(17\)S&gt;   "20081124/00000008"
                                         END: &lt;VSTR\(48\)&gt;      "QELEMENT"

                                    QELEMENT: &lt;LONG\(10\)&gt;      "5"
                                 QELEMENT_ID: &lt;LONG\(10\)S&gt;     "5"
                              QELEMENT_STATE: &lt;VSTR\(132\)S&gt;    "JOIN"
                     VSTR\_KEY$GEN\_VSTR_INDEX: &lt;VSTR\(80\)S&gt;     "EQUENS1100C081124081124081124"
                      SYSTIME$GEN\_VSTR_INDEX: &lt;TIME\(23\)S&gt;     "24-NOV-2008 12:17:44.78"
                          TXT$GEN\_VSTR_INDEX: &lt;VSTR\(20\)S&gt;     "2008112400000014"
                         HISTORY_COORDINATES: &lt;HST_ID\(23\)S&gt;   "2/3"
                                  MESSAGE_ID: &lt;MSG_ID\(17\)S&gt;   "20081124/00000014"
                                         END: &lt;VSTR\(48\)&gt;      "QELEMENT"

                                         END: &lt;VSTR\(48\)&gt;      "QUEUE"

SHOW:[QUEUE:/NLA///ACHO_EQU_IDX ALL: END: ]
please find the attachment for more clarity .
but my concern is can i reform the text file into below o/p
TYPE MSG ID
EQUENS1100 20081124/00000014
20081124/00000008
20081119/00000214
EQUENS0002 20081124/00000058
20081119/00000218

this type column we fetched from VSTR_KEY$GEN_VSTR_INDEX in attached file and each types are associated with MESSAGE_ID .
any help will really appreciated........................

manas_ranjan · December 9, 2008, 12:06pm

any suggestion on below problem....