MATLAB: Changing the string “JF 2009” to two seperate strings “J 2009″ ” F2009″ (reposted)

cell array

Dear all I have the following cell matrix
A={
 1  'SLO'    ' '             
 1  'SLO'    ' '            
 1  'SLO'    'JF 2009'     
 1  'SLO'    'MA 2009'     
 1  'SLO'    'MJ 2009'     
 1  'SLO'    'JA 2009'     
 1  'SLO'    'SO 2009'     
 1  'SLO'    'ND 2009'    
 1  'SLO'    'JF 2010'    
 1  'SLO'    'MA 2010'     
 1  'SLO'    'MJ 2010'     
 1  'SLO'    'JA 2010'     
 1  'SLO'    'SO 2010'     
 1  'SLO'    'ND 2010'     
 1  'SLO'    'JF 2011'     
 1  'SLO'    'MA 2011'     
 1  'SLO'    'MJ 2011'     
 1  'SLO'    'JA 2011'     
 2  'SLO'    ' '             
 2  'SLO'    ' '            
 2  'SLO'    'JF 2009'     
 2  'SLO'    'MA 2009'     
 2  'SLO'    'MJ 2009'     
 2  'SLO'    'JA 2009'     
 2  'SLO'    'SO 2009'     
 2  'SLO'    'ND 2009'     
 2  'SLO'    'JF 2010'     
 2  'SLO'    'MA 2010'     
 2  'SLO'    'MJ 2010'     
 2  'SLO'    'JA 2010'     
 2  'SLO'    'SO 2010'    
 2  'SLO'    'ND 2010'     
 2  'SLO'    'JF 2011'     
 2  'SLO'    'MA 2011'     
 2  'SLO'    'MJ 2011'    
 2  'SLO'    'JA 2011'     
  }
As you can see I have bimontly data. I want to modify the last column so as to have months like
 Amodified={
   1  'SLO'    ' '             
   1  'SLO'    ' '            
   1  'SLO'    'J  2009'     
   1  'SLO'    'F 2009'     
   1  'SLO'    'M 2009'     
   1  'SLO'    'A 2009'     
   1  'SLO'    'M 2009'     
   1  'SLO'    'J 2009'    
   1  'SLO'    'J 2010' }
and so forth
The previous answers were correct and I thank these guys. Yet their code can be applied for small number of individuals. In my case I have 30000 individuals.
Could you please help me?
thanks

Best Answer

Amodified = [];
for jj = 1:size(A,1)
    if ~strcmp(A{jj,3},' ')
        z = [A([jj,jj],1:2),...
            [{[A{jj,3}(1),A{jj,3}(3:end)]};...
             {[A{jj,3}(2),A{jj,3}(3:end)]}]];
    else
        z = A([jj],:);
    end
    Amodified = [Amodified;z];
end
Related Question