MATLAB: Bubble sorting (Index exceeds the number of array elements)

Question

I'm supposed to write a program that bubblesorts surnames. Porg file contains surnames while Klucze file contains keys assigned to surnames.

global Staff
global keys
fid = fopen ('Porg.csv')
fid2 = fopen ('Klucze.csv')
i=2
while ~feof(fid); ~feof(fid2)
      sd=fgetl(fid);
      zd=fgetl(fid2)
      tet(1:3)=strsplit(sd,';');
      zet(1:3)=strsplit(zd,' ');
      Staff(i).surname=tet(1);
      Staff(i).name=tet(2);
      keys(i).key=zet(1);
    i=i+1;
  end
  for x=2:(i-1)
          v(1)=Staff(x).surname;
          v(2)=Staff(x).name;
             v(3)=keys(x).key;
              disp(v);
      end

This code displays surnames together with names and assigned keys. Tried to bubble sort it by changing the last loop, and I keep getting an error "Index exceeds the number of array elements (1)". Does anyone know how to fix it? Probably it's a rookie mistake (I'm a newbie when it comes to programming)

g = length('Porg.csv')
        for j=2:(g-1);
        if j(g)>j(g+1);
        temp=Staff(j).surname;
           Staff(j).surname = Staff(j+1).surname; 
           Staff(j+1).surname = temp
         end
           v(2)=Staff(h).name;
           v(3)=keys(h).key;
            disp(v);
    end

Answer 1

Hi Karolina,

I always use xlsread instead of fopen. It is always easier to see what's going on with cell arrays or table structs.

Please try below code:

[~, ~ , Porg] = xlsread('Porg.csv'); % gets raw Porg data
[~, ~ , Klucze] = xlsread('Klucze.csv'); % gets raw Klucze data
mergedTable = horzcat(Porg,Klucze); % merges two tables together horizontally
sortedTable = sortrows(mergedTable,1);   % sorts by first column (surname)
newProg = sortedTable(:,1:3); % seperates first 3 column into new Prog data
newKlucze = sortedTable(:,4); % seperates last column into new Klucze data
xlswrite('newPorg.csv',newPorg); % saves your new cell array into a csv file again.
xlswrite('newKlucze.csv',newKlucze);