How to extract rows if column starts with a specific string?
9 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Lee
le 18 Août 2018
Commenté : Walter Roberson
le 18 Août 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 commentaires
Réponse acceptée
Walter Roberson
le 18 Août 2018
ExtractedRows = Data( startsWith(Data.SampleName,'13C'), : );
2 commentaires
Image Analyst
le 18 Août 2018
Nice to let people know of this new function. +1 vote. Will be useful to those who have R2016b or later.
Walter Roberson
le 18 Août 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
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Tables dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!