Delete duplicate values from string array

26 次查看（过去 30 天）
Tatjana Mü
Tatjana Mü 2022-5-17
回答： Mitch Lautigar 2022-5-17
Hi,
I have a string array with different elements. They are random from sample to sample. In some rows I have duplicates from some elements. Which should be remove. But sadly I don't find a correct way.
SP_RL = ["Na","Mg","Mg","Si"; "K","Ca","Rb"; "Sr","Sr","Pt"]
In the end I want to have it like this:
SP_RL = ["Na","Mg","Si"; "K","Ca","Rb";"Sr","Pt"]
I tried it already with unique in a loop to delete the duplicates row after row:
for x=1:number_rows
SP_RL(x,:)=unique(SP_RL(x,:));
end
At the moment I am out of ideas, because I tried everything. Does somebody has experience with the same problem?
Thank you :-)
  6 个评论
显示 4更早的评论
Tatjana Mü
Tatjana Mü 2022-5-17
@Thorsten that's bad... Ok like you mentioned I could turn it into a long vector. Does this means I have every row in a long vector or the whole matrix in one?
Torsten
Torsten 2022-5-17
编辑：Torsten 2022-5-17
You can first delete the duplicates rowwise and afterwards put the resulting (possibly shortened) rows in a long vector.
It should also be possible to turn your matrix into a cell array. Then each row can have a different number of elements, I guess. But I'm not an expert with this kind of data structure.
You can also keep the matrix structure if you replace the duplicate strings by another string, e.g. "Deleted".

请先登录，再进行评论。

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

回答（1 个）

Mitch Lautigar
Mitch Lautigar 2022-5-17
You need to use strcmpi() which will compare strings ignoring case and have it index through each spot of the array to compare the strings.
Unique() is best for sorting numbers. Hope this helps!

类别

在 Help Center 和 File Exchange 中查找有关 Characters and Strings 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by