How to split alphanumerical string without delimiter?

2016 10 14
1 个回答
回答已采纳
更新时间：2016 10 14
1 次查看（30 天）

0 个投票

Dear community,
I am dealing with .csv tables which contain one column of strings 'A1';'A2';...;'A100';...;'An';'B1';'B2';...;'B100';...;'Bn';'C1';'C2';...;'C100';...;'Cn';. I need to have them sorted to 'A1';'B1';'C1';'A2';'B2';'C2';...;'A100';'B100';'C100';...;'An';'Bn';'Cn'. After trying sort_nat, natsort, sortrows I tried splitting the strings which I do not know how to do without delimititer like e.g. a semicolon and sort for the numerical part. So, question: how to split strings by character without delimiter and sort by the numerical part? Thank you in adavance.

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

 采纳的回答

Andrei Bobrov
Andrei Bobrov 2016-10-14

0 个投票

f = fopen('Data20161014.csv'); % Data20161014.csv - your csv file
c = textscan(f,'%s','delimiter','\n');
fclose(f);
[~,ii] = sort(str2double(regexp(c{:},'\d+','match','once')));
out = c{:}(ii);

5 个评论
显示 3更早的评论 隐藏 3更早的评论

Mario
Mario 2016-10-14
Thank you very much Andrei Bobrov for this fast response! Of course it works. Where, however, do I tell the target colum to sort by, which is the sixth column in my data?
Andrei Bobrov
Andrei Bobrov 2016-10-14
Please attach your file with data (small part of him).
Andrei Bobrov
Andrei Bobrov 2016-10-14
f = fopen('test_1.csv');
c = textscan(f,repmat('%s ',1,129),'delimiter',',','headerlines',1);
fclose(f);
[~,ii] = sort(str2double(regexp(c{6},'\d+','match','once')));
out = cellfun(@(x)x(ii),c(1:end-1),'un',0);
Mario
Mario 2016-10-14
Thank you very much for your help, Andrei Bobrov, this is great!

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by