How to modify selected rows of one variable in table

Hi there,

Is there a way to code the following more elegantly? What this loop does is to

1. select rows from a table based on some criteria
2. then does some calculation on data in each row of that selection
3. writes the result into a new variable in that table (in that specific row)

% ListNexafs is a table and here I select a set of rows that meet these
% criteria. tmpMatch is a logical array:
tmpMatch  = (month(ListNexafs.lastModifiedDatenum) == 8) &...
        (year(ListNexafs.lastModifiedDatenum) == 2020);
% for each line of the tabe
for ii = 1:size(ListNexafs,1) 
%     if that line meets the criteria above (logical is 1)
    if tmpMatch(ii)
%         I do some calculations. IzeroAugInCell(:,1) and (:,2) are doubles
%         array. 
        ListNexafs.uhvI0{ii} = interp1(IzeroAugInCell(:,1),IzeroAugInCell(:,2),ListNexafs.xRayEkin_eV{ii});
    end
end

This works. But its not so elegant. Could this be done with cellfun (even though, IzeroAugInCell are not cells)? Or is there another way to get rid of the nested for and if ? Thanks for any help, Thorsten

[Matt J]

Is each cell ListNexafs.uhvI0{ii} vector-valued? And are the vectors contained in each cell of different lengths?

[ThorBarra]

Yes, these fields are part of a larger table with cells containing vectors of different length.

Answer 1

[Matt J]

fun=@(c) interp1(IzeroAugInCell(:,1),IzeroAugInCell(:,2), c);

ListNexafs.uhvI0(tmpMatch) = cellfun(fun, ListNexafs.xRayEkin_eV(tmpMatch)  ,'uni' , 0);

[ThorBarra]

Works like a charme. Again, something learned! Merci.