Read and extract specific values from a textfile

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.

[Stephen23]

@Happy PhD: please do both of these:

1. upload a sample data file by clicking the paperclip button.
2. show the expected output for the uploaded file.

[Happy PhD]

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];

Answer 1

[Stephen23]

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