How to read two columns from a text file that does not only consist of a table?

Question

Hannah 2021-8-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/896842-how-to-read-two-columns-from-a-text-file-that-does-not-only-consist-of-a-table

评论： Hannah 2021-8-12

t1_r1_c1125oE-mon.txt

I have a text file (see attachment) that I want to import into MATLAB. How can I only read/ store the columns 'month' and 'H-Gh'? i.e. I want my output to be:

Jan 33

Feb 52

Mar 97

Apr 123

May 161

Jun 178

Jul 176

Aug 153

Sep 105

Oct 63

Nov 33

Dec 24

so far I only managed to read one element from one column:

 while ischar(tline) %returns 1 if tline is a character array and 0 otherwise.
              colonLocation = strfind(tline, ['Sep']); %returns the starting indices of any occurrences of PATTERN in TEXT
              
              if ~isempty(colonLocation)
                subString = tline(:,[4:7])
                output(k) = str2double(subString);
                k = k + 1;
              end
              tline = fgetl(fid);
            end
            
            fclose(fid);

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2021-8-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/896842-how-to-read-two-columns-from-a-text-file-that-does-not-only-consist-of-a-table#answer_765482

在 MATLAB Online 中打开

filename = 'https://www.mathworks.com/matlabcentral/answers/uploaded_files/709847/t1_r1_c1125oE-mon.txt';
T = readtable(filename, 'Headerlines', 12);
subset = T(1:12, {'Month', 'H_Gh'})
subset = 12×2 table
     Month     H_Gh
    _______    ____

    {'Jan'}     33 
    {'Feb'}     52 
    {'Mar'}     97 
    {'Apr'}    123 
    {'May'}    161 
    {'Jun'}    178 
    {'Jul'}    176 
    {'Aug'}    153 
    {'Sep'}    105 
    {'Oct'}     63 
    {'Nov'}     33 
    {'Dec'}     24 