How do I read in a text file and sort it by a column
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have a file which I am trying to read and then sort by column A and then by column C. The text file is attached and has 3 columns. This is what I have tried but it will not let me use the sort function after reading it in this way:
function data = ResultsScript(filename)
fid = fopen(filename);
data = textscan(fid, '%s %f %f');
fclose(fid);
end
Then I call this function and try to sort it using:
fileName = 'Example.txt';
A = ResultsScript(fileName);
sortrows(A,[1,3]);
Running this gives the following error message:
??? Index exceeds matrix dimensions.
Error in ==> sortrows>sort_cell_back_to_front at 133
ndx = ndx(ind);
Error in ==> sortrows at 90
ndx = sort_cell_back_to_front(x_sub, col);
Error in ==> GetResults at 3
sortrows(A,[1,3]);
Any help is greatly appreciated.
2 commentaires
Réponse acceptée
sixwwwwww
le 12 Oct 2013
Dear Aaron, the problem here is that function "textscan" output data in the form of cell array which you must convert first into a matrix before using "sortrows" function because "sortrows" only accept vector or matrix data. So after converting it to proper form you can apply "sortrows". Also don't use "%s" to read values of double type instead use "%f" or better "%n". Following is the corrected code for this purpose:
fid = fopen(filename);
cell_data = textscan(fid, '%n %n %n');
fclose(fid);
matrix_data = [cell_data{:}];
After this you can apply:
sorted_data = sortrows(matrix_data, [1 3]);
2 commentaires
sixwwwwww
le 12 Oct 2013
You are welcome and sorry for misunderstanding about EPC because I don't know about EPC.
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Data Type Conversion dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!