changing the string "JF 2009" to two seperate strings "J 2009" " F2009" (reposted)

Question

salva 2012-7-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/44559-changing-the-string-jf-2009-to-two-seperate-strings-j-2009-f2009-reposted

Dear all I have the following cell matrix

A={

'SLO'    ' '             
'SLO'    ' '            
'SLO'    'JF 2009'     
'SLO'    'MA 2009'     
'SLO'    'MJ 2009'     
'SLO'    'JA 2009'     
'SLO'    'SO 2009'     
'SLO'    'ND 2009'    
'SLO'    'JF 2010'    
'SLO'    'MA 2010'     
'SLO'    'MJ 2010'     
'SLO'    'JA 2010'     
'SLO'    'SO 2010'     
'SLO'    'ND 2010'     
'SLO'    'JF 2011'     
'SLO'    'MA 2011'     
'SLO'    'MJ 2011'     
'SLO'    'JA 2011'     
'SLO'    ' '             
'SLO'    ' '            
'SLO'    'JF 2009'     
'SLO'    'MA 2009'     
'SLO'    'MJ 2009'     
'SLO'    'JA 2009'     
'SLO'    'SO 2009'     
'SLO'    'ND 2009'     
'SLO'    'JF 2010'     
'SLO'    'MA 2010'     
'SLO'    'MJ 2010'     
'SLO'    'JA 2010'     
'SLO'    'SO 2010'    
'SLO'    'ND 2010'     
'SLO'    'JF 2011'     
'SLO'    'MA 2011'     
'SLO'    'MJ 2011'    
'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={
'SLO'    ' '             
'SLO'    ' '            
'SLO'    'J  2009'     
'SLO'    'F 2009'     
'SLO'    'M 2009'     
'SLO'    'A 2009'     
'SLO'    'M 2009'     
'SLO'    'J 2009'    
'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

3 个评论
显示 1更早的评论隐藏 1更早的评论

Azzi Abdelmalek 2012-7-26

from where are your importing your data, excell? are they from workspace?

Azzi Abdelmalek 2012-7-26

i tryed with a 30000x1 array , and it works!

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Andrei Bobrov 2012-7-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/44559-changing-the-string-jf-2009-to-two-seperate-strings-j-2009-f2009-reposted#answer_54627

编辑：Andrei Bobrov 2012-7-26

在 MATLAB Online 中打开

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

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

salva 2012-7-26

thank you all

请先登录，再进行评论。

Answer 2

Azzi Abdelmalek 2012-7-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/44559-changing-the-string-jf-2009-to-two-seperate-strings-j-2009-f2009-reposted#answer_54620

编辑：Azzi Abdelmalek 2012-7-26

在 MATLAB Online 中打开

%i tryed this code to test a 30000x3 array

 for k=1:10;A=[A;A];end       % A is now a 36864x3
 n=size(A,1)
 c1=num2cell([1:n]')
 a=[c1 A]
 b=sortrows(a,4)
 B=b(:,4)
 d=max(find(cellfun(@(x) length(x)>2,B)==0))
 C=b(d+1:end,:)
 n1=size(C,1)
 ind1=1:2:2*n1-1;ind2=2:2:2*n1,C1=C;C2=C;
 C1(:,4)=cellfun(@(x) strtrim(regexprep(x,x(1),'')),C(:,4),'UniformOutput',false)
 C2(:,4)=cellfun(@(x) strtrim(regexprep(x,x(2),'')),C(:,4),'UniformOutput',false)
 D=cell(n1*2,4); D(ind1,:)=C2; D(ind2,:)=C1;
 E=sortrows([b(1:d,:) ; D],1);
 Result=E(:,2:4)