Skipping a line no delimiters in an array

3 views (last 30 days)
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
  3 Comments
Walter Roberson
Walter Roberson on 26 Oct 2021
We need to know if this is a text file (such as .csv) or a .xlsx file.

Sign in to comment.

Accepted Answer

Scott MacKenzie
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)),:) = []
M = 4×5
1 2 3 4 5 6 7 8 9 10 55 66 77 88 99 98 76 54 32 1
  3 Comments
Scott MacKenzie
Scott MacKenzie on 29 Oct 2021
@Abbey Stock ok, sure. I just altered my solution to work with any number of title lines in different rows.

Sign in to comment.

More Answers (0)

Products


Release

R2019b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by