AGG Software Forums
September 20, 2024, 01:25:02 AM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Welcome on our forum!
 
  Home Help Search Login Register  
  Show Posts
Pages: [1]
1  Online Help Center / Other questions / Re: reading a logfile in excel in real-time on: June 08, 2015, 10:00:00 AM
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  Online Help Center / Other questions / reading a logfile in excel in real-time on: April 15, 2015, 10:00:00 AM
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
Pages: [1]
Powered by SMF 1.1.21 | SMF © 2015, Simple Machines