How to check whether a column exist in a table?
조회 수: 486 (최근 30일)
이전 댓글 표시
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
Carlos Aguilar
2017년 12월 31일
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);
채택된 답변
KSSV
2016년 11월 24일
Exist_Column = strcmp('My_Column',My_Table.Properties.VariableNames)
val = Exist_Column(Exist_Column==1) ;
댓글 수: 6
Nikolaus Koopmann
2022년 11월 29일
any("MyColumn" == string(My_Table.Properties.VariableNames))
추가 답변 (2개)
Sean Lynch
2021년 9월 5일
I used "any", but agree "ismember" is even better
exists = any(strcmp('Column-Name', My_Table.Properties.VariableNames))
참고 항목
카테고리
Help Center 및 File Exchange에서 Structures에 대해 자세히 알아보기
제품
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!