Skipping a line no delimiters in an array
3 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Abbey Stock
el 26 de Oct. de 2021
Editada: Scott MacKenzie
el 29 de Oct. de 2021
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 comentarios
Walter Roberson
el 26 de Oct. de 2021
We need to know if this is a text file (such as .csv) or a .xlsx file.
Respuesta aceptada
Scott MacKenzie
el 26 de Oct. de 2021
Editada: Scott MacKenzie
el 29 de Oct. de 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)...
![](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 comentarios
Scott MacKenzie
el 29 de Oct. de 2021
Editada: Scott MacKenzie
el 29 de Oct. de 2021
@Abbey Stock ok, sure. I just altered my solution to work with any number of title lines in different rows.
Más respuestas (0)
Ver también
Categorías
Más información sobre Text Files en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!