How to extract rows if column starts with a specific string?
조회 수: 10 (최근 30일)
이전 댓글 표시
I have a data table that contains columns like this:
SampleName = {'13C3099';'13C3045';'14C3092';'14C3013'};
pH = [5.3822;4.382;4.9873;6.001];
Data = table(SampleName,pH)
I am trying to extract all the rows that have a sample name that starts with "13C". I have tried:
ExtractedRows = Data(:,Data.SampleName == '13C')
But I get the error "Undefined operator '==' for input arguments of type 'cell'." Can anyone help me identify what I am doing wrong?
댓글 수: 0
채택된 답변
Walter Roberson
2018년 8월 18일
ExtractedRows = Data( startsWith(Data.SampleName,'13C'), : );
댓글 수: 2
Image Analyst
2018년 8월 18일
Nice to let people know of this new function. +1 vote. Will be useful to those who have R2016b or later.
Walter Roberson
2018년 8월 18일
I think I learned it from Guillaume in https://www.mathworks.com/matlabcentral/answers/408631-finding-files-without-a-specfic-prefix-or-suffix-extension-etc-using-dir#answer_327337
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Characters and Strings에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!