how to sort table by row sub-string values?
7 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hi
I have a table like shown in the first picture. I'd like to sort this table using the last 2 characters of string, for example, 01A58, 02A58, 01A59, I'd like to sort it by 58 or 59. The 2nd pictures show the table I'd like to have . How to do it? I am looking at the command below and still not sure how to do it? Anyone can help me? Thanks
0 commentaires
Réponse acceptée
Star Strider
le 26 Juil 2021
Try this —
wellname = {'01A58' rand; '01A59' rand; '01A62' rand; '01A63' rand; '01A66' rand; '01A58' rand; '01A59' rand}
wellnamesuffix = extractAfter(wellname(:,1),'A')
[wellsort,ix] = sort(wellnamesuffix)
wellname_sorted = wellname(ix,:)
.
.
2 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Characters and Strings 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!