Accessing log4j log file using Birt?

Options
Macamba
edited February 11, 2022 in Analytics #1
Hi,

I want to read the contents of a log file generated using log4j from my Application. The log file has the following format:
25 apr 08 - 11:17:23,667 Object - Description

I pointed to the correct folder (containing the log file), selected UTF-8 as charset (working on Windows XP), and used PSV (pipe-separated values, considering a space to be the same as a pipe) as flatfile style. Finally I deselected 'Use first lie as column name indicator'.

I selected the *.* 'File Filter' to be able to see my log file. Next I could only choose COLUMN_1. When I previewed the results, the lines in the logfile where all put under COLUMN_1.

Where I am interested in is how can I instruct Birt to use spaces as the delimiter so the lines in my log file are split up?

Abel