MATLAB Answers

2

How to check whether a column exist in a table?

Asked by Alon Rozen on 24 Nov 2016
Latest activity Commented on by Gabriel Blanco on 25 Jun 2019
Accepted Answer by KSSV
Hi all,
I search for this question in the web and found the following solution: Suppose I have a table named 'My_Table' and want to check if it contains a column (field) named 'My_Column'. The code:
Exist_Column = strmatch('My_Column',My_Table.Properties.VariableNames)
should result in logical that answer the question. I checked it and it works. However, the Matlab editor commented that 'strmatch' is not a recommended function to use because it is about to be removed in future version and suggest instead the use of either 'strncmp' or 'validatestring'. Problem is that both do not return a logical and more steps are required to get the answer.
So, my question is: what is the simplest recommended way to determine if a certain column name exist in a table?
Thanks,
Alon

  1 Comment

Just came across to this question. An anonymous function will also do the job (and will be reusable within the scope):
isTableCol = @(t, thisCol) ismember(thisCol, t.Properties.VariableNames);

Sign in to comment.

Products

2 Answers

Answer by KSSV
on 24 Nov 2016
 Accepted Answer

Exist_Column = strcmp('My_Column',My_Table.Properties.VariableNames)
val = Exist_Column(Exist_Column==1) ;

  5 Comments

any(strcmp('My Column', My_Table.Properties.VariableNames))
ismember('My Column', My_Table.Properties.VariableNames)

Sign in to comment.


Answer by jkr
on 14 May 2019

sum(ismember(mx.Properties.VariableNames,'NameYouWantToCheck'))
returns 1 if found, 0 if not

  0 Comments

Sign in to comment.