Remove headers from multiple .dat files (EEM Matrices)
2 views (last 30 days)
Show older comments
Hello! I currently have a large number of matrices in .dat files that I would like to load. These matrices have three rows of headers and one column that I would like to have removed before continuing. The person who had worked with these matrices before me use to load the matrices one by one to excel and manually remove the top three rows and the first column. They would then load the files into matlab using this script.
files = dir('*.dat');
for i=1:length(files)
eval(['load ' files(i).name ' -ascii']);
end
If anybody has any suggestions, I would love to be able to remove the unwanted rows and columns in matlab, rather than manually removing them in excel. Below I have copied just part of one of the matrices to give you an idea of what I am working with. The 0's are part of the desired matrix, everything else is not.
Best, Thomas
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/165928/image.png)
0 Comments
Answers (1)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!