how to sort table by row sub-string values?

Question

0 个投票

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更早的评论

请先登录，再进行评论。

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

Follow Question

Answer 1

Star Strider 2021-7-26

在 MATLAB Online 中打开

0 个投票

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 个评论
显示无隐藏无

roudan 2021-7-26

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

Star Strider 2021-7-26

As always, my pleasure!

.

请先登录，再进行评论。

how to sort table by row sub-string values?

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

采纳的回答

2 个评论
显示无隐藏无

更多回答（0 个）

类别

产品

版本

标签

Community Treasure Hunt

how to sort table by row sub-string values?

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

采纳的回答

2 个评论 显示 无 隐藏 无

更多回答（0 个）

类别

产品

版本

标签

另请参阅

Community Treasure Hunt

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

2 个评论
显示无隐藏无