Reordering string arrays if string is >9

Question

Jason 2020-3-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/511496-reordering-string-arrays-if-string-is-9

评论： Jason 2020-3-18

Hello, I have a string array that has been sorted but puts 10 next to 1

b = 
  1×6 string array
    "1"    "10"    "3"    "5"    "7"    "r1"

My strings are upto 12.

I want the last element to remain where it is, and to move any strings > 9 if exist to the end -1

i.e.

"1" "3" "5" "7" "10" "r1"

and if I have

"1" "10" "12" "5" "7" "r1"

then to be

"1" "5" "7" "10" "12" "r1"

This is my attempt:

              b
                Id10 = find(contains(b,"10"))               
                
                if Id10>0
                    e=b(Id10); b(Id10)=[]; b(end-1)=e;                  
                    out{j,1}=b;
                    b
                end
                Id11 = find(contains(b,"11"))
                if Id11>0
                    e=b(Id11); b(Id11)=[]; b(end-1)=e;                  
                    out{j,1}=b;
                    b
                end
                Id12 = find(contains(b,"12"))
                if Id12>0
                    e=b(Id12); b(Id12)=[]; b(end-1)=e;                  
                    out{j,1}=b;
                end
                b

but it seems to be over writing the end-1 element

b = 
  1×7 string array
    "1"    "10"    "11"    "12"    "3"    "6"    "r1"
Id10 =
     2
b = 
  1×6 string array
    "1"    "11"    "12"    "3"    "10"    "r1"
Id11 =
     2
b = 
  1×5 string array
    "1"    "12"    "3"    "11"    "r1"
Id12 =
     2
b = 
  1×4 string array
    "1"    "3"    "12"    "r1"

Thanks for any help

2 个评论
显示无隐藏无

BobH 2020-3-18

在 MATLAB Online 中打开

This statement shortens the array (same for Id11/12)

b(Id10)=[];

All you were missing is a statement to restore the size, by copying the last element onto the end.

Then you could overwrite end-1

b(end+1) = b(end);  % copy last element onto end
b(Id10)=[];  % remove '10'
b(end-1) = e;  % overwrite end-1

Jason 2020-3-18

Perfect, thankyou very much!

请先登录，再进行评论。

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

Answer 1

BobH 2020-3-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/511496-reordering-string-arrays-if-string-is-9#answer_420709

在 MATLAB Online 中打开

sort_nat is powerful, and has helped me several times.

An alternative for simple number/not-number values is straightforward

find the locations of the numbers
sort those
append the not-numbers

 z = cellfun(@(X) logical(~isempty(str2num(X))),b);  % z shows locations of number strings
 n = cellfun(@str2num, b(z));  % into numerical
 [~, ix] = sort( n );  % ix tells what order to pull from b
 r = b(ix);  % fill the result using sorted numbers
 r{end+1} = b{~z};  % append the not-numbers

6 个评论
显示 4更早的评论隐藏 4更早的评论

Jason 2020-3-18

Thanks Bob, that will always be the case for me

BobH 2020-3-18

在 MATLAB Online 中打开

Just for completeness, for those who might have numbers anywhere, here's a more general solution

find the locations of the numbers
build a new numeric vector, using a placeholder number for the not-numbers. Inf or -Inf are good choices that will sort to the end or the front
use the sort index to pull from b

z = cellfun(@(X) logical(~isempty(str2num(X))),b);  % z shows locations of number strings
n(~z) = Inf;   % placeholder value; makes not-strings sort to end 
n(z) = cellfun(@str2num, b(z));
[~, ix] = sort( n );
r = b(ix);

请先登录，再进行评论。

Answer 2

dpb 2020-3-18

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/511496-reordering-string-arrays-if-string-is-9#answer_420707

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Jason 2020-3-18

在 MATLAB Online 中打开

Thanks, but Im running into an error

b = 
  1×6 string array
    "1"    "3"    "6"    "8"    "9"    "r1"
Index in position 1 exceeds array bounds.
Error in sort_nat (line 62)
	num_val(i,z(i,:)) = sscanf(sprintf('%s ',digruns{i}{:}),'%f');
Error in PlateSeq2JB/LockPositionsButtonPushed (line 693)
               [b,~] = sort_nat(b)