I have to make a program that goes through a text file and extracts numerical values, I am having a hard time extracting those numbers, here is what I have so far. The text file also has a lot if letters associated with it to

6 Comments

Shawntae Harris
Shawntae Harris on 22 Jul 2020
Edited: per isakson on 22 Jul 2020
Here is the text file
I need the tempreture of 2 1,3,4 are not needed
MATLAB does not permit us to copy and paste pictures of code or text and have them processed as text.
So the lines for '2 FAIL OPEN_CIRCUIT' should be located? And is it the 22.8125 that you need, or the 100 0.00 on the next line that you need?
the tempretures need to be located so yes the 22.8125 but only the ones associated with the "2 FAIL-"
also this is just a picture of the text file the text file is an actual .txt file

Sign in to comment.

 Accepted Answer

filename = 'HypothesisTest2.txt';
S = fileread(filename);
temperatures = str2double( regexp(S, '^(?<=2 FAIL OPEN_CIRCUIT Int ')[\d.]+', 'match') );

4 Comments

I am having a problem with the bracket before the backslash by d,+'
here is the error
temperatures = str2double( regexp(S, '^(?<=2 FAIL OPEN_CIRCUIT Int ')[\d.]+', 'match') );
Error: Unbalanced or unexpected parenthesis or
bracket.
temperatures = str2double( regexp(S, '^(?<=2 FAIL OPEN_CIRCUIT Int )[\d.]+', 'match') );
I do have a problem as it returns an array of NaN. I think this is due to the fact that there are cell array of cell arrays.
If you were to post an actual file instead of an image of a file, I could test...
Oh, I do see one problem:
temperatures = str2double( regexp(S, '^(?<=2 FAIL OPEN_CIRCUIT Int )[\d.]+', 'match', 'lineanchors') );

Sign in to comment.

More Answers (1)

Mohammad Sami
Mohammad Sami on 22 Jul 2020
Edited: Mohammad Sami on 22 Jul 2020
Assuming the pattern shown in your picture. Ignore line 1, line 2& line 3 form a repeating pattern.
I would suggest read the entire file first. Then we split it by line. Then put the line following line 2 pattern together and same for line3.
file = 'filename.txt';
fid = fopen(file,'r');
rawtxt = fread(fid,'*char')';
rawtxt = splitlines(rawtxt);
line2s = rawtxt(2:2:end);
line3s = rawtxt(3:2:end);
line2txt = strjoin(line2s,newline);
line3txt = strjoin(line3s,newline);
out2 = textscan(line2txt,'%f FAIL OPEN_CIRCUIT Int %f degC');
out3 = textscan(line3txt,'%f %f W/m^2');

1 Comment

I would need it to be a for loop as the text file can vary for sizes

Sign in to comment.

Categories

Products

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!