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
Walter Roberson
2021년 10월 26일
We need to know if this is a text file (such as .csv) or a .xlsx file.
채택된 답변
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!