Hi sorry, this is an Access Query. All the data that I have is from an OpenVMS Sysuaf.lis file which is completely unorganised, as you can see below, there is no real structure but there are key words which identify what we need to extract.

IDFullContent

446Primary days: Mon Tue Wed Thu Fri

447Secondary days: Sat Sun

448No access restrictions

449Expiration: (none) Pwdminimum: 8 Login Fails: 0

450Pwdlifetime: 30 00:00 Pwdchange: (pre-expired)

451Last Login: (none) (interactive), (none) (non-interactive)

452Maxjobs: 0 Fillm: 1024 Bytlm: 130000

453Maxacctjobs: 0 Shrfillm: 0 Pbytlm: 0

454Maxdetach: 0 BIOlm: 4096 JTquota: 8192

455Prclm: 10 DIOlm: 4096 WSdef: 100000

456Prio: 4 ASTlm: 250 WSquo: 200000

457Queprio: 0 TQElm: 20 WSextent: 210000

458CPU: (none) Enqlm: 2000 Pgflquo: 4000000

459Authorized Privileges:

460ACNT ALLSPOOL ALTPRI AUDIT BUGCHK BYPASS

461CMEXEC CMKRNL DIAGNOSE DOWNGRADE EXQUOTA GROUP

462GRPNAM GRPPRV IMPERSONATE IMPORT LOG_IO MOUNT

463NETMBX OPER PFNMAP PHY_IO PRMCEB PRMGBL

464PRMMBX PSWAPM READALL SECURITY SETPRV SHARE

465SHMEM SYSGBL SYSLCK SYSNAM SYSPRV TMPMBX

466UPGRADE VOLPRO WORLD

467Default Privileges:

Sample Data:

IDFullContent

459Authorized Privileges:

460ACNT ALLSPOOL ALTPRI AUDIT BUGCHK BYPASS

461CMEXEC CMKRNL DIAGNOSE DOWNGRADE EXQUOTA GROUP

462GRPNAM GRPPRV IMPERSONATE IMPORT LOG_IO MOUNT

463NETMBX OPER PFNMAP PHY_IO PRMCEB PRMGBL

464PRMMBX PSWAPM READALL SECURITY SETPRV SHARE

465SHMEM SYSGBL SYSLCK SYSNAM SYSPRV TMPMBX

466UPGRADE VOLPRO WORLD

467Default Privileges:

Output Expected:

"

ACNT,ALLSPOOL,ALTPRI,AUDIT,BUGCHK,BYPASS,CMEXEC,CMKRNL,DIAGNOSE,DOWNGRADE,EXQUOTA,GROUP,GRPNAM,GRPPRV,IMPERSONATE,IMPORT,LOG_IO,MOUNT,NETMBX,OPER…etcc"

The delimiter can be anything.