I have a file like this

QUEUE: <ITEM(69)> "/NLA///ACHO_EQU_IDX"
Q_KEY: <ITEM(69)> "/NLA///ACHO_EQU_IDX"
Q_TYPE: <VSTR(32)> "GEN_VSTR_INDEX"
QOBJ_TYPE: <VSTR(32)> "MSG_HISTORY_SEQ"
Q_DOMAIN: <VSTR(7)> "MESSAGE"
DUP_KEY_FLAG: <STR(1)> "Y"
PERIODIC_FLAG: <STR(1)> "N"
UNION_ID: <BITS(8)X> "00000000"
USED_BYTES: <LONG(10)X> "0"
ALLOCATED_BYTES: <LONG(10)X> "0"

QELEMENT: <LONG(10)> "1"
QELEMENT_ID: <LONG(10)S> "1"
QELEMENT_STATE: <VSTR(132)S> "JOIN"
VSTR_KEY$GEN_VSTR_INDEX: <VSTR(80)S> "EQUENS0002C081119081119081119"
SYSTIME$GEN_VSTR_INDEX: <TIME(23)S> "19-NOV-2008 20:55:34.38"
TXT$GEN_VSTR_INDEX: <VSTR(20)S> "2008111900000218"
HISTORY_COORDINATES: <HST_ID(23)S> "2/3"
MESSAGE_ID: <MSG_ID(17)S> "20081119/00000218"
END: <VSTR(48)> "QELEMENT"

QELEMENT: <LONG(10)> "2"
QELEMENT_ID: <LONG(10)S> "2"
QELEMENT_STATE: <VSTR(132)S> "JOIN"
VSTR_KEY$GEN_VSTR_INDEX: <VSTR(80)S> "EQUENS0002C081124081124081124"
SYSTIME$GEN_VSTR_INDEX: <TIME(23)S> "24-NOV-2008 12:51:51.83"
TXT$GEN_VSTR_INDEX: <VSTR(20)S> "2008112400000058"
HISTORY_COORDINATES: <HST_ID(23)S> "2/3"
MESSAGE_ID: <MSG_ID(17)S> "20081124/00000058"
END: <VSTR(48)> "QELEMENT"

QELEMENT: <LONG(10)> "3"
QELEMENT_ID: <LONG(10)S> "3"
QELEMENT_STATE: <VSTR(132)S> "JOIN"
VSTR_KEY$GEN_VSTR_INDEX: <VSTR(80)S> "EQUENS1100C081119081119081119"
SYSTIME$GEN_VSTR_INDEX: <TIME(23)S> "19-NOV-2008 20:54:15.93"
TXT$GEN_VSTR_INDEX: <VSTR(20)S> "2008111900000214"
HISTORY_COORDINATES: <HST_ID(23)S> "2/3"
MESSAGE_ID: <MSG_ID(17)S> "20081119/00000214"
END: <VSTR(48)> "QELEMENT"

QELEMENT: <LONG(10)> "4"
QELEMENT_ID: <LONG(10)S> "4"
QELEMENT_STATE: <VSTR(132)S> "JOIN"
VSTR_KEY$GEN_VSTR_INDEX: <VSTR(80)S> "EQUENS1100C081124081124081124"
SYSTIME$GEN_VSTR_INDEX: <TIME(23)S> "24-NOV-2008 11:15:48.27"
TXT$GEN_VSTR_INDEX: <VSTR(20)S> "2008112400000008"
HISTORY_COORDINATES: <HST_ID(23)S> "2/3"
MESSAGE_ID: <MSG_ID(17)S> "20081124/00000008"
END: <VSTR(48)> "QELEMENT"

QELEMENT: <LONG(10)> "5"
QELEMENT_ID: <LONG(10)S> "5"
QELEMENT_STATE: <VSTR(132)S> "JOIN"
VSTR_KEY$GEN_VSTR_INDEX: <VSTR(80)S> "EQUENS1100C081124081124081124"
SYSTIME$GEN_VSTR_INDEX: <TIME(23)S> "24-NOV-2008 12:17:44.78"
TXT$GEN_VSTR_INDEX: <VSTR(20)S> "2008112400000014"
HISTORY_COORDINATES: <HST_ID(23)S> "2/3"
MESSAGE_ID: <MSG_ID(17)S> "20081124/00000014"
END: <VSTR(48)> "QELEMENT"

END: <VSTR(48)> "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........................

Attached Files

sample.txt (5.0 KB, 15 views)

any suggestion on below problem....