News:

Welcome on our forum!

Main Menu
Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Messages - AliG

#1
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.
#2
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