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

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..

Answer 1

[Walter Roberson]

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

[Gopal Pande]

I will add more description here,

my csv file has data with size Eg. [1853 * 152] (rows,columns)

There is one blank row only and after that i will have my data to read and copy to another cell. position or row number is not fixed.

Eg. first two rows I have data then third row is blank row

next I may have data in 153 rows and next is blank row

next i may have data in 12 rows and then blank row.

I want to copy data into another cell until i find first blank row, then i want to copy next data into another cell until there is next blank row.

my data is can be sorted lets say by detecting blank row and need to copy data evrytime in new cell array/matrix.

[Walter Roberson]

This code should handle that.

[Gopal Pande]

in second line of code what is a, I may get it as undefined?

[Walter Roberson]

Darn, I am having trouble with the mobile interface.

The a in that line should be any

[Gopal Pande]

New lines of code works better than previous.

But in blocks var blank row is getting copied into another cell, I want to copy data and not blank row which can be seperated/identified by NaN.

But thanks anyway, i am also debugging this code further to get what is intended...

[Walter Roberson]

 starts = findstr([false, mask], [0,1]) + 1;