how to sort table by row sub-string values?

Question

roudan 2021-7-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/886479-how-to-sort-table-by-row-sub-string-values

评论： Star Strider 2021-7-26

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Star Strider 2021-7-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/886479-how-to-sort-table-by-row-sub-string-values#answer_754339

在 MATLAB Online 中打开

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