MATLAB: Transfer lines in a text file to a new text file

text file

I need to transfer lines between two text files into a new text file. The text file in which I need to match lines is called m21rmmorphU.txt, and I need to match the lines belonging in the text file,virgoclusterrm.txt, that also belong in m21rmmorphU.txt, into a new text file.

So, I want to extract the lines that match in m21rmmorphU.txt from virgoclusterrm.txt into a new text file and remove the matched lines from m21rmmorphU.txt.

Files are attached.

Best Answer

You can do something along this line:

 content1 = fileread( 'm21rmmorphU.txt' ) ;
 content2_rows = strsplit( fileread( 'virgoclusterrm.txt' ), sprintf( '\n' )) ;
 found = cellfun( @(s)~isempty(strfind(content1, s)), content2_rows ) ;
 output_rows = content2_rows(found) ;
 fId = fopen( 'similar.txt', 'w' ) ;
 fprintf( fId, '%s\n', output_rows{:} ) ;
 fclose( fId ) ;

Related Solutions

MATLAB: Need to remove ‘~’ in column 5 of text file

UPDATE 5:04pm

 % - Read original.

 content = fileread( 'mwithin21rm.txt' ) ;
 % - Match and eliminate lines without pattern matching.
 sepId = reshape( strfind( content, '|' ), 18, [] ) ;
 match = content(sepId(4,:)+1) == '~' ;
 lines = strsplit( content, '\n' ) ;
 lines(match) = [] ;
 % - Export updated content.

 fId = fopen( 'm21rmmorphU.txt', 'w' ) ;
 fprintf( fId, strjoin( lines, '\n' )) ;
 fclose( fId ) ;

FORMER

If I understand well (in particular about col. 5), you want something like this:

 % - Read original.
 content = fileread( 'mwithin21rm.txt' ) ;
 % - Replacement which avoids pattern matching.
 sepId  = reshape( strfind( content, '|' ), 18, [] ) ;
 match  = content(sepId(4,:)+1) == '~' ;
 content(sepId(4,match)+1) = '' ;
 % - Export updated content.
 fId = fopen( 'm21rmmorphU.txt', 'w' ) ;
 fwrite( fId, content ) ;
 fclose( fId ) ;

PS: I love regular expressions ;-) but this seems to be a case where we can avoid their complexity.

MATLAB: Export matched lines from two text files

Here is a first draft. Test it and let me know if anything is unclear or doesn't work.

 % - Read files content as strings.
 content1 = fileread( 'mwithrm21.txt' ) ;
 content2 = fileread( 'virgomrmdist.txt' ) ;
 % - Extract last column of each content.
 codes1 = regexp( content1, '[^|]+(?=(\s|$))', 'match' ) ;
 codes2 = regexp( content2, '[^|]+(?=(\s|$))', 'match' ) ;
 % - Matches codes.
 [isMatch_1in2, match_posIn2] = ismember( codes1, codes2 ) ;
 % - Split content. Careful, whatever generates these files still uses
 %  carriage returns (\r) only.
 rows1 = strsplit( content1, char(13) ) ;
 rows2 = strsplit( content2, char(13) ) ;
 % - Output matches (version mwithrm21.txt). Use new line chars (\n) as 
 %  joint instead of carriage returns, change if you prefer \r.
 fId = fopen( 'matches.txt', 'w' ) ;
 fwrite( fId, strjoin( rows1(isMatch_1in2), '\n' )) ;
 fclose( fId ) ;
 % - Output non-matching rows of file 1.
 fId = fopen( 'mwithrm21_reduced.txt', 'w' ) ;
 fwrite( fId, strjoin( rows1(~isMatch_1in2), '\n' )) ;
 fclose( fId ) ;
 % - Output non-matching rows of file 2. Eliminate matching rows first.
 rows2(nonzeros( match_posIn2 )) = [] ;
 fId = fopen( 'virgomrmdist_reduced.txt', 'w' ) ;
 fwrite( fId, strjoin( rows2, '\n' )) ;
 fclose( fId ) ;

EDITs :

Replaced match_posIn2(match_posIn2~=0) with nonzeros( match_posIn2 ) after reading an answer by Matt J in another thread that mentions NONZEROS.

Best Answer

Related Solutions

MATLAB: Need to remove ‘~’ in column 5 of text file

MATLAB: Export matched lines from two text files

Related Question