Skipping a line no delimiters in an array
3 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
Scott MacKenzie
2021-10-26
编辑:Scott MacKenzie
2021-10-29
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)...
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/779558/image.jpeg)
the following script reads all the data, then removes the non-numeric rows:
M = readmatrix('test2.xlsx');
M(isnan(M(:,1)),:) = []
3 个评论
Scott MacKenzie
2021-10-29
编辑:Scott MacKenzie
2021-10-29
@Abbey Stock ok, sure. I just altered my solution to work with any number of title lines in different rows.
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Text Files 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!