MATLAB: Xlswrite, strfind, excel problem.

excel

My excel file is been created as shown at "result.jpg".
I want something as shown at "WhatIWant.jpg"
The txt file is uploaded as "items.txt"
Thanks.
 function x=testt()
 fid = fopen('items.txt','r');
 k=1;
 while 1
    tline = fgetl(fid);
    if strfind(tline, 'AbilityCooldown')>0
        x=strfind(tline, 'AbilityCooldown')
%          tline(x:end)
         sprintf('%s   %f',tline)
          my_cell = sprintf( 'A%s',num2str(k) );
          xlswrite('testitens2.xlsx',tline,'Sheet1',my_cell);
          k=k+1;
    end  
     if ~ischar(tline)
        break
     end
 end
 end

Best Answer

fid = fopen('items.txt') ;
S = textscan(fid,'%s','delimiter','\n') ;
S = S{1} ;
idx = strfind(S, 'AbilityCooldown');
idx = find(not(cellfun('isempty',idx)));
%
ACD = S(idx) ;
b=regexp(ACD,'\d+(\.)?(\d+)?','match') ;
iwant=str2double([b{:}])
You have the AbilityCooldown numbers in array, you can write into excel at a stretch.
Related Question