Using external table to load files with fixed pattern

From: suri <suriawan_at_gmx.de>
Date: 2 Mar 2006 09:05:56 -0800
Message-ID: <1141319156.308316.77050@t39g2000cwt.googlegroups.com>

Hi,

I have a log file with following pattern:

[<log ID>] <log message>
< several lines of detail messages

   .......
>

Time: <date>
Process: <process ID>

---

[<log ID>] <log message>
< several lines of detail messages

   .......
>

Time: <date>
Process: <process ID>

---

Is it possible using external table feature to load that file to table and put the values of each attribute <...> to different column?

Thanks for your help,
Suri Received on Thu Mar 02 2006 - 11:05:56 CST