Trying to parse a text file and want to capture only the "objectname", "operationalstate" and "operationalstatedetail" fields. So far i've gotten the syntax as logparser "select text from 'testfile.txt' where text like '%objectname%'" but i'm unable to get the remaining 2 fields and i need them in respective order of their "objectname" as there are multiple instances of those fields in the 1 text file. Any help would be appreciated.
Excerpt from text file:
objectid .............................: 00000000000000000000000000 objectname ...........................: Array name
objecttype ...........................: storagecell
objectwwn ............................: 0000-0000-0000-0000
objecthexuid .........................: 0000-0000-0000-0000-0000-0000-0000-0000
storagesystemcontrollermemory ........: 512
storagesystemcontrollercachememory ...: 2048
uid ..................................: 8.7.0000.0000.0000.0000.0000
operationalstate .....................: good
operationalstatedetail ...............: initialized_ok
comments .............................:
hexuid ...............................: 0000-0000-0000-0000-0000-0000-0000-0000
objectparentuid ......................: 0.0.0.0.0.0.0
objectparenthexuid ...................: 0000-0000-0000-0000-0000-0000-0000-0000
objectparentid .......................: 0000000000000000000000000000000000000000
controllertime
day ................................: 06
month ..............................: 04
year ...............................: 2009
hour ...............................: 16
minute .............................: 19
second .............................: 43
systemtype ...........................: XXXXXXXXX