Access data in table - how to chose a range of columns indexed by cell

Is it possible in Matlab to select a range (not single) of columns in a table indexed by cells and not integers?

I was thinking something like table(:,{'varname1'} : {varname2})

Answer 1

[Greg]

See the documentation. "Index Using a Logical Expression" section of the following page:

https://www.mathworks.com/help/matlab/matlab_prog/access-data-in-a-table.html#zmw57dd0e25752

I'll take a swing that what you really want is all columns between varname1 and varname2 (whether inclusive or not). Your best be in that case is to do some string matching to turn varname1 and varname2 into column indices, then use the colon operator in the indexing expression.

Answer 2

[turquoise_squid]

So yeah, what I usually do is this

% cellfind = @(string)(@(cell_contents)(strcmp(string,cell_contents))); % logical_cells = cellfun(cellfind('this is string'),vars.Properties.VariableNames)

I find this complicated though :)

thought there would be an easier way.