Find column names with particular names in MATLAB table

Hi there,

I have a massive table with 408 columns in MATLAB. I want to get rid of columns that start with the word "connected". Instead of having to manually check the table and do something like

finalnbs(:,212:364) = [];

Where

finalnbs

is the table, how do I find all columns in finalnbs which start with connected e.g.

connected*

And then remove those?

[harjeet singh]

please upload mat table, and let me know the datatype of finalnbs

Answer 1

[Walter Roberson]

finalnbs(:,strncmp(finalnbs.Properties.VariableNames, 'connected', length('connected')) ) = [];

Answer 2

[Renato Agurto]

Hello

if "titles" is the first row of your table, then:

 titles = finalnbs(1,:);

 %Select the columns that should stay
 idxs = cellfun(@(x) length(x) < 9 || ~strcmp(x(1:9),'connected'),titles);

 finalnbs = finalnbs(:,idxs);

Answer 3

[Joseba Moreno]

Hello,

I have a similar problem but in my case I would like to remove the columns which contain the word "free".

How can I do that?

Thanks!

Joseba

[Walter Roberson]

With new enough matlab you can use contains() to test whether a substring occurs somewhere in a string .

[Peter Perkins]

or strfind in older versions.