How to extract rows if column starts with a specific string?

Question

Lee 2018-8-18

评论： Walter Roberson 2018-8-18

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?

Answer 1

Walter Roberson 2018-8-18

ExtractedRows = Data( startsWith(Data.SampleName,'13C'), : );

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