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

9 Ansichten (letzte 30 Tage)
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?

Akzeptierte Antwort

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

Weitere Antworten (0)

Kategorien

Mehr zu Characters and Strings finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by