How to extract rows if column starts with a specific string?
9 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Lee
am 18 Aug. 2018
Kommentiert: Walter Roberson
am 18 Aug. 2018
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 Kommentare
Akzeptierte Antwort
Walter Roberson
am 18 Aug. 2018
ExtractedRows = Data( startsWith(Data.SampleName,'13C'), : );
2 Kommentare
Image Analyst
am 18 Aug. 2018
Nice to let people know of this new function. +1 vote. Will be useful to those who have R2016b or later.
Walter Roberson
am 18 Aug. 2018
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
Weitere Antworten (0)
Siehe auch
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!