How to get all the first five columns from a text file?

Question

Juan Rosado 2013-2-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/64564-how-to-get-all-the-first-five-columns-from-a-text-file

在 MATLAB Online 中打开

I am trying to get all the first five columns starting from the third row of this text five.

This is the text file,

http://www.ndbc.noaa.gov/data/realtime2/41053.txt ,

This is the function I created,

 function    Data = SJ 
 fid = fopen( 'SJ.txt' );
        Data = textscan( fid, '%d%d%d%d%d%f%f%f%f%f%s%s%s%f%f%f%f%f%f' ...
                    ,   'Delimiter'             ,   ' '     ...
                    ,   'CollectOutput'         ,   true    ...
                    ,   'HeaderLines'           ,   2       ...
                    ,   'MultipleDelimsAsOne'   ,   true    ...
                    ,   'Whitespace'            ,   ''      ...
                    );
        fclose( fid );
    end

Every time I run it I only get the first five columns of the third row stored on the Data{1,1} cell.

Can you please help?

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

请先登录，再进行评论。

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

Answer 1

per isakson 2013-2-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/64564-how-to-get-all-the-first-five-columns-from-a-text-file#answer_76146

编辑：per isakson 2013-2-23

在 MATLAB Online 中打开

Do you really mean "the first five columns"? That's only date and time. However, this format string does that

'%d%d%d%d%d%*[^\n]'

it says: read the first five columns and skip the rest of the row.

Alternative: Add the line

, 'TreatAsEmpty' , 'MM' ...

to textscan. All "MM" in numeric columns will be returned as NaN. Otherwise, reading stops at first "MM" in a numeric column (a column with "%f" in the format).