Read and extract specific values from a textfile

Question

Happy PhD 2022-1-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1638025-read-and-extract-specific-values-from-a-textfile

编辑： Stephen23 2022-1-28

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 个评论
显示无隐藏无

Stephen23 2022-1-28

@Happy PhD: please do both of these:

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

Happy PhD 2022-1-28

编辑：Happy PhD 2022-1-28

在 MATLAB Online 中打开

test.txt

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 2022-1-28

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1638025-read-and-extract-specific-values-from-a-textfile#answer_883735

编辑：Stephen23 2022-1-28

在 MATLAB Online 中打开

test.txt

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