Hi all

I have this .txt file with lots of data... example below

PGM
GRTMQMAUT MQMNAME('BMTA4C01') +
OBJ('ITS.SYSTEST.STUBQ.1') +
OBJTYPE(*LCLQ) USER(QSECOFR) +
AUT(*BROWSE *ADMCHG *ADMCLR *ADMDLT *ADMDSP *GET *INQ *PUT +
*PASSALL *PASSID *SET *SETALL *SETID )
What I want to do is get the object name OBJ(... and populate a column in another sheet with that name, then if something above is present i want the corresponding column to show an X. So above as there is AUT & PUT (as well as others) I would like under the AUT and PUT columns in sheet 2 to show an X to mark that its present for that object name.

any ideas?

Cheers.