how to sort table by row sub-string values?

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

https://www.mathworks.com/help/matlab/ref/double.sortrows.html;jsessionid=4992d4c41e79cd32b6857a4308ac

Answer 1

[Star Strider]

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]}

.

.

[roudan]

Yes it worked perfectly. Thank you Star Strider. I appreciate it

[Star Strider]

As always, my pleasure!

.