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

19 views (last 30 days)
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?

Accepted Answer

Walter Roberson
Walter Roberson on 18 Aug 2018
ExtractedRows = Data( startsWith(Data.SampleName,'13C'), : );

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!