Skipping a line no delimiters in an array
2 views (last 30 days)
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 on 26 Oct 2021
Edited: Scott MacKenzie on 29 Oct 2021
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)),:) =