How to read line by line from one file and find each line to another file and locate it?

Question

Kona 2016-2-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/269390-how-to-read-line-by-line-from-one-file-and-find-each-line-to-another-file-and-locate-it

评论： Guillaume 2016-2-22

Dear all,

I have 2 .csv files. The first thing i want to do is to read the first file line by line. All these lines are in the second file but in different row. I need to find where in the second file is each of the line (the number of line). Does anyone konw how to solve this problem?

Best regrds, Konstantina

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Guillaume 2016-2-22

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/269390-how-to-read-line-by-line-from-one-file-and-find-each-line-to-another-file-and-locate-it#answer_210760

在 MATLAB Online 中打开

A simple way:

leftcontent = strsplit(fileread('c:\somewhere\your\1stfile.csv'), {'\n', '\r'}); %read 1st file and split into lines
rightcontent = strsplit(fileread('c:\somewhere\your\2ndfile.csv'), {'\n', '\r'}); %read 1st file and split into lines
[foundinright, locationinright] = ismember(leftcontent, rightcontent)

locationinright contains the line number where each line of the first file is found in the second file (or 0 if not present), in the order of the lines in the first file.

3 个评论
显示 1更早的评论隐藏 1更早的评论

Kona 2016-2-22

I had two columns!! I concatenated them in one and the problem is solved! Thank you again!!!

Guillaume 2016-2-22

在 MATLAB Online 中打开

It means that your version of matlab is older than R2013a (always a good idea to specify your matlab version if it's old), since that's where strsplit was introduced.

You can replace the code with:

findeol = sprintf('(?:%c|%c)+', 13, 10);
leftcontent = regexp(fileread('c:\somewhere\your\1stfile.csv'), findeol, 'split'); %read 1st file and split into lines
rightcontent = strsplit(fileread('c:\somewhere\your\2ndfile.csv'), findeol, 'split'); %read 1st file and split into lines
[foundinright, locationinright] = ismember(leftcontent, rightcontent)