How to read rows until I find blank row in csv file and copy to another cell?

17 次查看（过去 30 天）

Gopal Pande 2020-9-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/596290-how-to-read-rows-until-i-find-blank-row-in-csv-file-and-copy-to-another-cell

评论： Walter Roberson 2020-9-22

I have .csv file with data.after few rows there are blank rows, blank row can be after 2 rows or after 5 rows or maybe after 150 rows it's not fixed. I wanted to copy data until find blank row and create seperate cell to use it further and do same with next rows of data until I find next blank row. Stuck with logic, tried using readmatrix(filename), tried detecting blank row from 'NaN' string Not able to solve this problem..

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

请先登录，再进行评论。

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

回答（1 个）

Walter Roberson 2020-9-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/596290-how-to-read-rows-until-i-find-blank-row-in-csv-file-and-copy-to-another-cell#answer_497104

编辑：Walter Roberson 2020-9-19

在 MATLAB Online 中打开

 d = readmatrix(filename)
 mask = any(isnan(d), 2).';
 starts = findstr([false, mask], [0,1]);
 stops = findstr([mask, false], [1,0]);
blocks = arrayfun(@(s,e)d(s:e,:), starts, stops, 'uniform', 0);