Create function to extract data from .log file

Dear all,

I want to write a function can extract data from log file. It like that

The number marked yellow is the number what I want to output and then used to do the calculate. I would really appreciate that if anyone can provide any help.

Thanks in advance.

Answer 1

[Walter Roberson]

S = fileread('NameOfYourLogFileGoesHere.log');
value_of_interest_string = regexp('(?<=it\.it-nin\.icytot\.nrep2\.mtfail\.IMPES:\s*)\S+', 'match');
value_of_interest = str2double(value_of_interest_string);

This code does not assume that the value is an integer, just that it appears after the mtfail.IMPES: string and ends in whitespace.

[Cedric]

It would probably work with the shorter pattern:

 '(?<=IMPES:\s*)\S+'

[Walter Roberson]

Probably Yes ;-) But just in case there is another IMPES: in the file...

[Cedric]

That's not IMPESsible! ;-)

[haisheng yu]

Thanks a lot. I just run this code return the NaN. I will take a look of the regexp function. Thanks again.

[Cedric]

There is a typo that I didn't spot: the first argument in the call to REGEXP should be the content to parse, which is variable S. Try with the following:

 S = fileread('NameOfYourLogFileGoesHere.log');
 value_of_interest_string = regexp(S, '(?<=it\.it-nin\.icytot\.nrep2\.mtfail\.IMPES:\s*)\S+', 'match');
 value_of_interest = str2double(value_of_interest_string);

and/or with the simpler pattern that I proposed:

 S = fileread('NameOfYourLogFileGoesHere.log');
 value_of_interest_string = regexp(S, '(?<=IMPES:\s*)\S+', 'match');
 value_of_interest = str2double(value_of_interest_string);

[haisheng yu]

Thanks a lot. It really help a lot. I also solved a way

 Str = fileread('WH Generated path_09.log');
Key = 'it,it-nin,icytot,nrep2,mtfail,IMPES:';
Index = strfind(Str,Key);
Value =sscanf(Str(Index(1)+length(Key):end),'%g',1);

[Walter Roberson]

Yes, sorry, I missed the S in the regexp call.