Effacer les filtres
Effacer les filtres

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

9 vues (au cours des 30 derniers jours)
Lee
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?

Réponse acceptée

Walter Roberson
Walter Roberson le 18 Août 2018
ExtractedRows = Data( startsWith(Data.SampleName,'13C'), : );
  2 commentaires
Image Analyst
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.

Connectez-vous pour commenter.

Plus de réponses (0)

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!

Translated by