Read and extract specific values from a textfile

3 views (last 30 days)
Hi, I am trying to extact values at diffrent positions from a file with different type of lines.
Example of some lines:
t= 0, CDL data, Dh 11.84, Dv -2.56, Gh 0.78, Gv 0.88
t= 2, CDL data, Dh 45.91, Dv -6.22, Gh -0.80, Gv 0.51
t= 62, CDL data, Dh 26.69, Dv -4.88, Gh -5.00, Gv 1.00
t= 124, CANT, P00, cosC 8.0000, sinC 3.0000
t= 142, CDL data, Dh -96.25, Dv -57.28, Gh 6.00, Gv -4.03
t= 1755, CANT, P00, cosC 5.0018, sinC 9.0081
t= 2022, CDL data, Dh 5.69, Dv -5.02, Gh 0.06, Gv -0.95
I want to read out vales after "Gh ", "Gv ", and "CANT, P00, cosC" and ", sinC ". .
I managed to extract time t = even if its annoying it changes position you have to account for that (no esier way to do this?), but the other ones are empty.
My code:
clear all
fileList = 'data.txt';
Gv = [];
Gh = [];
CANT = [];
t = [];
fid = fopen(fileList);
textLine = fgetl(fid);
blockCounter = 1;
while ischar(textLine)
%disp(textLine ) % Dsiplay text line in command window.
% Find time.
timeLocation = strfind(textLine, 't= ');
if timeLocation == 1
t(blockCounter) = sscanf(textLine, 't= %f')
end
timeLocation = 0;
timeLocation = strfind(textLine, 't= ');
if timeLocation == 1
t(blockCounter) = sscanf(textLine, 't= %f')
end
% Find Gv, Gh, CANT
GhLocation = strfind(textLine, 'Gh ');
if GhLocation == 1
Gh(blockCounter) = sscanf(textLine, 'Gh %f');
Gv(blockCounter) = sscanf(textLine, ', Gv %f');
% Now let's prepare for the next block.
blockCounter = blockCounter + 1;
end
CANTLocation = strfind(textLine, 'CANT, P00, ');
if CANTLocation == 1
CANT(blockCounter) = sscanf(textLine, 'CANT, P00, %f');
% Now let's prepare for the next block.
blockCounter = blockCounter + 1;
end
textLine = fgetl(fid);
end
fclose(fid);
Any help appreciated.
  2 Comments
Happy PhD
Happy PhD on 28 Jan 2022
Edited: Happy PhD on 28 Jan 2022
Inputs, see attacted file:
Extected outputs:
t = [0
2
62
142
2022];
Gh = [0.78
-0.8
-5.0
6
0.06],
Gv = [0.88
0.51
1.0
-4.03
-0.95];
CANT = [8.0 3.0
5.0018 9.0081];
t_CANT = [124
1755];

Sign in to comment.

Answers (1)

Stephen23
Stephen23 on 28 Jan 2022
Edited: Stephen23 on 28 Jan 2022
The numeric values below are in two matrices, you can use indexing to extract the t, Gh, etc. vectors.
format short G
str = fileread('test.txt')
str =
't= 0, CDL data, Dh 11.84, Dv -2.56, Gh 0.78, Gv 0.88 t= 2, CDL data, Dh 45.91, Dv -6.22, Gh -0.80, Gv 0.51 t= 62, CDL data, Dh 26.69, Dv -4.88, Gh -5.00, Gv 1.00 t= 124, CANT, P00, cosC 8.0000, sinC 3.0000 t= 142, CDL data, Dh -96.25, Dv -57.28, Gh 6.00, Gv -4.03 t= 1755, CANT, P00, cosC 5.0018, sinC 9.0081 t= 2022, CDL data, Dh 5.69, Dv -5.02, Gh 0.06, Gv -0.95'
tkn = regexp(str,'t=\s+(\d+)[^\n]+?Gh\s+(\S+),\s+Gv\s+(\S+)','tokens');
tGhGv = str2double(vertcat(tkn{:}))
tGhGv = 5×3
1.0e+00 * 0 0.78 0.88 2 -0.8 0.51 62 -5 1 142 6 -4.03 2022 0.06 -0.95
tkn = regexp(str,'t=\s+(\d+)[^\n]+?cosC\s+(\S+),\s+sinC\s+(\S+)','tokens');
tCANT = str2double(vertcat(tkn{:}))
tCANT = 2×3
1.0e+00 * 124 8 3 1755 5.0018 9.0081

Products


Release

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by