MATLAB: Fill cell in second column based on first column cell array

cell arraycontainsfindinsert valuereplace

I have a cell array of image names in the first column ('9_X_0_a.bmp', '9_X_0_b.bmp','19_X_0_a.bmp', '19_X_0_b.bmp', etc.). I would like to fill the second column with either '1' or '2' based on if the image names contain 'a' or 'b'.
I currently have the code set to run as an 'if' statement which works but only for one index. In other words, it will place the proper number in the second column for either 'a' or 'b' images, but not for both. Any advice?
for i = length(listOfFiles1);
    indexa = find(contains(listOfFiles1, 'a'));
    indexb = find(contains(listOfFiles1, 'b.bmp'));
    if i == indexa
        listOfFiles1{indexa,2} = 1;
    elseif i == indexb
        listOfFiles1{indexb,2} = 2;
    end
end

Best Answer

Method one: regexp and convert using subtraction:
>> C = {'9_X_0_a.bmp';'9_X_0_b.bmp';'19_X_0_a.bmp';'19_X_0_b.bmp'};
>> D = regexp(C,'[ab](?=\.bmp)','match','once');
>> C(:,2) = num2cell([D{:}]-'a'+1)
C =
   '9_X_0_a.bmp'     1
   '9_X_0_b.bmp'     2
   '19_X_0_a.bmp'    1
   '19_X_0_b.bmp'    2
Method two: regexprep:
>> C = {'9_X_0_a.bmp';'9_X_0_b.bmp';'19_X_0_a.bmp';'19_X_0_b.bmp'};
>> C(:,2) = regexprep(C,{'.*a\.bmp$','.*b\.bmp'},{'1','2'}) % as string
C =
   '9_X_0_a.bmp'     '1'
   '9_X_0_b.bmp'     '2'
   '19_X_0_a.bmp'    '1'
   '19_X_0_b.bmp'    '2'
or as double:
D = regexprep(C,{'.*a\.bmp$','.*b\.bmp'},{'1','2'});
C(:,2) = num2cell(str2double(D));
Related Question