Rearranging text file order

Hi guys. I have a text file that has a few rows and columns: Name WIN LOSE

I have a few data of names, win, and lose sorted.

I'm having difficulties figuring out a way to rearrange the text file data from higher to lower win score while bringing the particular lose and name row specifics along .. how do i do this ? Please help me out :S

Answer 1

[Michael Haderlein]

I'm not 100% sure if I understood your question correctly, but this might be what you need:

>> name={'A';'B';'C'};
>> score=[3;1;2];
>> [sort_score,ind]=sort(score);
>> sort_name=name(ind);
>> sort_score

sort_score =

       1
       2
       3

>> sort_name

sort_name = 

      'B'
      'C'
      'A'

Answer 2

[Guillaume]

You're not telling us how you're storing the content on your text file, so I'm assuming a cell array. In any case, to sort data according to a column and bring along the others, use sortrows:

scores = {'Player 1', 5, 3
          'Player 2', 4, 9
          'Player 3', 7, 1};
sortrows(scores, 2)

>> ans = 

    'Player 2'    [4]    [9]
    'Player 1'    [5]    [3]
    'Player 3'    [7]    [1]