take out numbers from string

Question

Jay Hanuman 2016-12-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/317450-take-out-numbers-from-string

评论： Jay Hanuman 2016-12-19

采纳的回答： Guillaume

clusterawdata.mat

在 MATLAB Online 中打开

I attached file which contains as this

'10.0.7.4:22->10.0.8.5:26856'
'10.0.13.4:22->10.0.12.5:9997'
'10.0.9.4:22->10.0.10.5:47576'
'10.0.14.4:443->10.0.10.5:4922'
'10.0.14.4:443->10.0.10.5:20113'
'10.0.11.4:80->10.0.13.5:61779'
'10.0.10.4:22->10.0.9.5:64788'
'10.0.9.4:80->10.0.10.5:25283'

I want to take out numbers appears after 1st and 2nd colon in two different variable. i.e. A=[22 22 443 443 80 22 80] and B=[26856 9997 47576 4922....] but A and B should be in column format. how to do it.

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

请先登录，再进行评论。

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

Answer 1

Guillaume 2016-12-19

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/317450-take-out-numbers-from-string#answer_247777

在 MATLAB Online 中打开

There's no point in creating two different variables when it's much easier to have the output as two columns of the same variable. Here's one way to do it:

suffix = regexp(VarName6, '(?<=:)\d+', 'match');  %match sequence of numbers following a :
suffix = str2double(vertcat(suffix{:}))           %convert cell array of cell arrays into one big cell array and convert strings to numeric

2 个评论
显示无隐藏无

José-Luis 2016-12-19

编辑：José-Luis 2016-12-19

I really should work on my regexes... +1

Jay Hanuman 2016-12-19

works Thank you.

请先登录，再进行评论。

Answer 2

José-Luis 2016-12-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/317450-take-out-numbers-from-string#answer_247776

编辑：José-Luis 2016-12-19

在 MATLAB Online 中打开

I'll get you started:

 data = [{'10.0.7.4:22->10.0.8.5:26856'};{'10.0.13.4:22->10.0.12.5:9997'}];
 result = cellfun(@(x) regexp(x,':[0-9]+','match'),data,'UniformOutput',false);
 a = cellfun(@(x) sscanf(x{1},':%d'),result);
 b = cellfun(@(x) sscanf(x{2},':%d'),result);