Skipping a line no delimiters in an array

Hi,

I have read in an excel file of data into an array and all the data has the same number of delimiters per line. I am trying to seperate this data by the "," delimiter which is already in the file which is no problem. However, every now and then there will be a row of just text with 0 delimiters that I would like to skip past when reading the array i have read the file into. These rows are just title rows explaining whats below, but I do not need these in the final array, just the raw data.

How can I skip past these rows? The row numbers for these rows will vary for each file i read in, so I am trying to avoid a solution where i skip past a line number.

Thank you in advance for your help

[Scott MacKenzie]

Are the data in a .csv file? It might help if you post the data.

[Ive J]

Can you provide a working example?

[Walter Roberson]

We need to know if this is a text file (such as .csv) or a .xlsx file.

Answer 1

[Scott MacKenzie]

From your comment, it seems you are working with an Excel file, as opposed to comma-delimited text file.

Given this and your description of the organization of the data, here's one approach. Using the example data in test2.xlsx (attached)...

the following script reads all the data, then removes the non-numeric rows:

M = readmatrix('test2.xlsx');
M(isnan(M(:,1)),:) = []

M = 4×5

1 2 3 4 5 6 7 8 9 10 55 66 77 88 99 98 76 54 32 1

[Abbey Stock]

Hello,

Thank you for your answer, however what if the data (in excel format) is:

title row with no delimiters

2728,7363,02927,62628,2284

3348830,28273,239292

title row with no delimiters

3298348,2983,29812

title row...

Where the file will be different each time with a different number of rows between title lines? How can i read this into an array ignoring the title lines and placing each number into a cell?

[Walter Roberson]

you will need to readcell and filter the results

[Scott MacKenzie]

@Abbey Stock ok, sure. I just altered my solution to work with any number of title lines in different rows.