Need to sort the number in the increasing order using MATLAB script, shown as a sample text file.
조회 수: 4 (최근 30일)
이전 댓글 표시
The current avilable pattern is as follows,
0.0,A
2.0,B
5.00,C
0.10,D
5.00,E
0.10,F
1.00,G
0.10,H
10.00,I
0.10,J
2.0,K
2.0,L
2.0,M
5.00,N
0.10,O
10.00,P
0.10,Q
The required pattern is as follows,
0.0,A
0.10,D
0.10,F
0.10,H
0.10,J
0.10,O
0.10,Q
1.00,G
2.0,B
2.0,K
2.0,L
2.0,M
5.00,C
5.00,E
5.00,N
10.00,I
10.00,P
댓글 수: 0
답변 (2개)
Stephen23
2019년 11월 29일
편집: Stephen23
2019년 11월 29일
You could download my FEX submission natsort:
And then import your file into a cell array of character vectors C:
C = regexp(fileread('new.txt'),'\S+','match');
D = natsort(C,'\d+\.?\d*'); % sort into the requested order.
Where D contains the sorted character vectors, which you can check:
>> D(:)
ans =
'0.0,A'
'0.10,D'
'0.10,F'
'0.10,H'
'0.10,J'
'0.10,O'
'0.10,Q'
'1.00,G'
'2.0,B'
'2.0,K'
'2.0,L'
'2.0,M'
'5.00,C'
'5.00,E'
'5.00,N'
'10.00,I'
'10.00,P'
If you want, save it to file:
[fid,msg] = fopen('out.txt','wt');
assert(fid>=3,msg)
fprintf('%s\n',D{:});
fclose(fid);
댓글 수: 3
Stephen23
2019년 12월 2일
편집: Stephen23
2019년 12월 2일
"Can you help me on this issue."
Of course. Here is the very first sentence of my answer:
"You could download my FEX submission natsort:"
Did you DOWNLOAD my FEX submssion from the link that I gave you? You will then need to unzip it into the current folder (or somewhere on the MATLAB Search Path).
Andrei Bobrov
2019년 11월 29일
T = readtable('new.txt')
T = sortrows(T)
writetable(T,'new2.txt','delimiter',',','WriteVariableNames',0)
댓글 수: 2
Stephen23
2019년 11월 29일
편집: Stephen23
2019년 11월 29일
Note that this method changes the numeric data format, the output file looks like this:
0.1,D
0.1,F
0.1,H
0.1,J
0.1,O
0.1,Q
1,G
2,B
2,K
2,L
2,M
5,C
5,E
5,N
10,I
10,P
Given the varaible number of trailing digits, it would be fiddly to make this work using writetable. The answer I provided gives the data in exactly the format shown in the question (i.e. unchanged from the input format).
참고 항목
카테고리
Help Center 및 File Exchange에서 Data Import and Export에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!