reading a logfile in excel in real-time

[AliG]

Dear All,

I want to be able to read a text logfile that is updated regularly (by adding new lines to it) and plot the values in excel in real time as and when the log file is updated!!
Is there any code or macro for this I can use as I have no programming knowledge?

Thanks for taking the time to reply back.

Regards,
AliG

[Arthur Grasin]

Hello,

You can use our Log Monitor & Export software: www.aggsoft.com/log-monitor.htm
Tutorials: http://www.aggsoft.com/log-monitor/tutorials.htm

[AliG]

thanks!
I tried your software; I managed to communicate with excel in real time but I don't know how to sparse/filter my data?

Example of my log file is below and i wan to be able to export only the data/time and values at the end:

10/21/2011;3:32:02 PM;C:\OPUS_7.0.122\process\simulator.OBS\21_10_11\15_32_01.0;-1.09;
10/21/2011;3:32:04 PM;C:\OPUS_7.0.122\process\simulator.OBS\21_10_11\15_32_03.0;-1.18;
10/21/2011;3:32:07 PM;C:\OPUS_7.0.122\process\simulator.OBS\21_10_11\15_32_06.0;-1.15;
10/21/2011;3:32:10 PM;C:\OPUS_7.0.122\process\simulator.OBS\21_10_11\15_32_09.0;-1.03;
10/21/2011;3:32:13 PM;C:\OPUS_7.0.122\process\simulator.OBS\21_10_11\15_32_12.0;-1.20;
10/21/2011;3:36:31 PM;C:\OPUS_7.0.122\process\simulator.OBS\21_10_11\15_36_30.0;-1.16;
10/21/2011;3:36:34 PM;C:\OPUS_7.0.122\process\simulator.OBS\21_10_11\15_36_33.0;-1.13;
10/21/2011;3:36:37 PM;C:\OPUS_7.0.122\process\simulator.OBS\21_10_11\15_36_35.0;-1.18;
10/21/2011;3:36:39 PM;C:\OPUS_7.0.122\process\simulator.OBS\21_10_11\15_36_38.0;-1.44;
10/21/2011;3:36:42 PM;C:\OPUS_7.0.122\process\simulator.OBS\21_10_11\15_36_40.0;-0.77;
10/21/2011;3:36:45 PM;C:\OPUS_7.0.122\process\simulator.OBS\21_10_11\15_36_43.0;-0.69;
10/21/2011;3:36:47 PM;C:\OPUS_7.0.122\process\simulator.OBS\21_10_11\15_36_46.0;-1.28;



thanks for you help.

[Arthur Grasin]

The tutorials sections contains examples. In your case your data is delimited by ";". You can use the ASCII Data Parser and split your data to columns.