Unique (partial) values

6 views (last 30 days)
Mario
Mario on 30 Sep 2017
Commented: Mario on 30 Sep 2017
Hi all! I have a cell array (imported by xlsread) of this kind:
'0.000000000' '185.47.162.26'
'0.000658000' '185.47.169.249'
'0.000793000' '177.10.146.49'
'0.003146000' '185.47.162.26'
'0.006683000' '185.47.162.26'
Now...i'm interested to select only rows corresponding to the first unique values of second column. So...in this example i need the following output:
'0.000000000' '185.47.162.26'
'0.000658000' '185.47.169.249'
'0.000793000' '177.10.146.49'
Unique function seems not to support a feature like this. Can you help me? Thx in advance! Mario

Answers (1)

Walter Roberson
Walter Roberson on 30 Sep 2017
[~, idx] = unique(YourCellArray(:,2), 'stable');
output = YourCellArray(idx, :);

Categories

Find more on Files and Folders in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!