Info

此问题已关闭。请重新打开它进行编辑或回答。

finding conetnts of a cell in another one

1 次查看（过去 30 天）

babak 2012-9-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/48723-finding-conetnts-of-a-cell-in-another-one

Here is what my data exactly is: File1 contains 1column x 1109rows and each cell contains numbers like this: 2.11.7.8

Rxn contains 7column x 1170rows. In every cells of column#5 exists numbers like what it was in file1 (2.11.7.8) I am going to compars every cells of file1 with cells of rxn column#5 and if the numbers were exactly the same, the whole content of the related row in rxn would be copied to a new matrix Please note that i need the exact properties of each cell

6 个评论
显示 4更早的评论隐藏 4更早的评论

Javier 2012-9-21

编辑：Javier 2012-9-21

在 MATLAB Online 中打开

Hello Babak

Ok big issue here but not impossible. The following procedure works in Matlab R2012a. No answer space so I answer here.

Step 1

Import 3 files: One will be Rxn (7 columns), File1 and other called "Var1" will be column 5 of Rxn. When you import this to Matlab you will have string information not data. Because the information is in Excel (for example) use the function num2str in the import process.

Step 2

Now, for each string in File1, we begging the search in Var1. This will work for the search of the first string in File1.

for i=1:1170

R(i,1)=sum(find(A(i,:)==File1(1,:)),2);

end

How R works. For 2.11.7.8 we have 8 characters. Then, if R= 36 all the string match and we find what we are looking for. If you remove the sum, an error will appear. At the end I provide a code that you can check. If the number of characters change, establish a condition in Step 3 according to string data search.

Step 3

R is column vector. Find in R the value 36. Remember, 2.11.7.8 we have 8 characters, and the sum of 1 to 8 is 36.

RR=find(R==36) %Now you have the rows

Step 4

New matrix and copy process

for i=1:size(RR,1)

Newm(i,:)=Rxn(RR(i,1),:)

end

Code

%Step 1 Search a value (A(1,:)). This is the first value in A. It could be the first element of File1

a=randn(100,4);

A=[num2str(abs(round(a(:,1)))),repmat('.11.',100,1),num2str(abs(round(a(:,2))))];

B=[num2str(abs(round(a(:,3)))),repmat('.11.',100,1),num2str(abs(round(a(:,4))))];

%My Rxn matrix (2 columns A,B)

Rxn=[A,B];

Var1=A; %search in this column

File1=A(1,:) %search this data

%Step 2

for i=1:size(Rxn,1)

R(i,1)=sum(find(Var1(i,:)==File1(1,:)),2);

end

%Step 3

RR=find(R==21) %Data are like 1.11.1, 6 characters and sum(1 to 6)=21

%Step 4

for i=1:size(RR,1)

Newm(i,:)=Rxn(RR(i,1),:)

end

Feel free to make a comment and verify that the code supplied works before comment.

Regards

Javier

babak 2012-9-21

thank you javier for your kind answer, i will try this procedure when i go access my pc, but my version is r2009a, can i run this procedure on this version?

babak 2012-9-21

i tried this but it didnt work, i'm totally confused, can i send my excel files to know what exactly my data are? it would be very kind of you!

此问题已关闭。

回答（0 个）

此问题已关闭。

Community Treasure Hunt

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

Start Hunting!

Translated by

finding conetnts of a cell in another one

6 个评论
显示 4更早的评论隐藏 4更早的评论

回答（0 个）

另请参阅

标签

Community Treasure Hunt

finding conetnts of a cell in another one

6 个评论 显示 4更早的评论隐藏 4更早的评论

回答（0 个）

另请参阅

标签

Community Treasure Hunt

6 个评论
显示 4更早的评论隐藏 4更早的评论