MATLAB Answers

how to sort table by row sub-string values?

1 view (last 30 days)
roudan
roudan on 26 Jul 2021
Commented: Star Strider on 26 Jul 2021
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

Accepted Answer

Star Strider
Star Strider on 26 Jul 2021
Try this —
wellname = {'01A58' rand; '01A59' rand; '01A62' rand; '01A63' rand; '01A66' rand; '01A58' rand; '01A59' rand}
wellname = 7×2 cell array
{'01A58'} {[0.5053]} {'01A59'} {[0.4580]} {'01A62'} {[0.9698]} {'01A63'} {[0.6966]} {'01A66'} {[0.2968]} {'01A58'} {[0.2999]} {'01A59'} {[0.3551]}
wellnamesuffix = extractAfter(wellname(:,1),'A')
wellnamesuffix = 7×1 cell array
{'58'} {'59'} {'62'} {'63'} {'66'} {'58'} {'59'}
[wellsort,ix] = sort(wellnamesuffix)
wellsort = 7×1 cell array
{'58'} {'58'} {'59'} {'59'} {'62'} {'63'} {'66'}
ix = 7×1
1 6 2 7 3 4 5
wellname_sorted = wellname(ix,:)
wellname_sorted = 7×2 cell array
{'01A58'} {[0.5053]} {'01A58'} {[0.2999]} {'01A59'} {[0.4580]} {'01A59'} {[0.3551]} {'01A62'} {[0.9698]} {'01A63'} {[0.6966]} {'01A66'} {[0.2968]}
.
.
  2 Comments

Sign in to comment.

More Answers (0)

Products


Release

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by