code that would identify the identical rows
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Alberto Acri
el 18 de Nov. de 2022
Comentada: Alberto Acri
el 18 de Nov. de 2022
Hello! I have a text file (.txt) consisting of 'M' rows and 3 columns. I would like to write a code that allows to identify the identical rows (the highlighted rows) and keep only one copy, of each repeated row, within the text file.
As a result, if a row repeats one or more times, I have to recreate the text file (.txt):
- keeping the lines that do not repeat
- bringing back only once the lines that are repeated
For example:
I thank you if anyone can help me!
0 comentarios
Respuesta aceptada
Arif Hoq
el 18 de Nov. de 2022
a=table2array(readtable("file.txt"));
output=unique(a,'rows','stable')
3 comentarios
Arif Hoq
el 18 de Nov. de 2022
a=table2array(readtable("file.txt"));
[output,ia,ic]=unique(a,'rows','stable')
index vector ic represents the repetition. Here indexes 1,7,13 are the duplicate rows as well 4,10.
Más respuestas (0)
Ver también
Categorías
Más información sobre String en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!