erasing specifi rows from a cell matrix

Dear all,
I have
A={
'12/08' ' '
'01/09' ' '
'02/09' ' '
'03/09' ' '
'03/09' ' '
'04/09' ' '
'05/09' ' '
'06/09' ' '
'07/09' ' '
'08/09' ' '
'09/09' ' '
'10/09' ' '
'11/09' ' '
'12/09' ' '
'01/10' '33 '
'01/10' '55 '
'02/10' ' '
'03/10' ' '
'04/10' ' '
'05/10' ' '
'06/10' ' '
'07/10' ' '
'08/10' ' '
'09/10' ' '
'10/10' ' '
'11/10' ' '
'12/10' ' '
'01/11' '123 '
'01/11' ' 321'
'02/11' ' '
'03/11' ' '
'04/11' ' '
'05/11' ' '
'06/11' ' '
'07/11' ' '
'08/11' ' '
'09/11' ' '
'10/11' ' '
'11/11' ' '}
I want to erase the second duplicate so as to have
A={
'12/08' ' '
'01/09' ' '
'02/09' ' '
'03/09' ' '
'03/09' ' '
'04/09' ' '
'05/09' ' '
'06/09' ' '
'07/09' ' '
'08/09' ' '
'09/09' ' '
'10/09' ' '
'11/09' ' '
'12/09' ' '
'01/10' '33 '
'02/10' ' '
'03/10' ' '
'04/10' ' '
'05/10' ' '
'06/10' ' '
'07/10' ' '
'08/10' ' '
'09/10' ' '
'10/10' ' '
'11/10' ' '
'12/10' ' '
'01/11' '123 '
'02/11' ' '
'03/11' ' '
'04/11' ' '
'05/11' ' '
'06/11' ' '
'07/11' ' '
'08/11' ' '
'09/11' ' '
'10/11' ' '
'11/11' ' '}
thanks

1 Kommentar

what about
'03/09' ' '
'03/09' ' '
they are identical, will you remove one ?

Melden Sie sich an, um zu kommentieren.

 Akzeptierte Antwort

Azzi Abdelmalek
Azzi Abdelmalek am 2 Aug. 2012
Bearbeitet: Azzi Abdelmalek am 2 Aug. 2012

0 Stimmen

[x,y]=unique(A(:,1),'stable');A=A(y,:)

Weitere Antworten (1)

Andrei Bobrov
Andrei Bobrov am 2 Aug. 2012
Bearbeitet: Andrei Bobrov am 2 Aug. 2012

0 Stimmen

[~,b] = unique(A(:,1),'first')
Aout=A(sort(b),:)
or
[c,c,c] = unique(A(:,1));
Aout=A(~([false;diff(c)==0]&~cellfun(@isempty,regexp(A(:,2),'\d*'))),:);

3 Kommentare

Sabbas
Sabbas am 2 Aug. 2012
Hi andrei,
the code above erases the first and not the second duplicate
thanks
Andrei Bobrov
Andrei Bobrov am 2 Aug. 2012
no, erases the second duplicate
Azzi Abdelmalek
Azzi Abdelmalek am 2 Aug. 2012
no, does'nt erase the second, it erase the second after sorting, for example change a value 321 with 32.

Melden Sie sich an, um zu kommentieren.

Kategorien

Mehr zu Data Types finden Sie in Hilfe-Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by