Dear All,
I have a log file that is dislpayed as:
Code:
<msg time='2009-10-14T05:46:42.580+00:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='mtdb_a'
host_addr='UNKNOWN' version='1'>
<txt>14-OCT-2009 05:46:42 * (CONNECT_DATA=(SID=fgs)(CID=(PROGRAM=sqlplus@mtdb)(HOST=mtdb_a)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.60.4.2)(PORT=34898)) * establish * fgs * 0
</txt>
</msg>
How can i grab in the <txt> the
1- Date
2- Time
3- Host
4 - All together seperated by a space
regards all