There are two files, A and B.
File A
1,1234,4567,890,1
2,2345,5678,891,2
3,3456,6789,891,3
File B
1,1234,4567,890
3,3456,6789,891
In this case, the
in file A. 2,2345,5678,891,2
Is it possible to extract only and write it to another file?
By the way, there are about 10,000 lines of files.
File A is 5 columns, file B is 4 columns, and the last column of file A is not in file B
The difference extraction is based on a comparison between the first four columns of file A and the fourth columns of file B.
Thank you for your cooperation.
emeditor
Remove the last column from file A, compare, and extract the modified row.For macros, activate file B, file A, and then run the following macros:After macro execution, be careful not to save the last column of file A as it has been deleted.
editor.ExecuteCommandByID (22528); // switch to CSV mode
document.selection.StartOfDocument(false);
document.selection.EndOfLine(false,eeLineView);
editor.ExecuteCommandByID (3962); // Delete Column
if(editor.Compare(0, "", "", "") == eDiff){
editor.ExecuteCommandByID (4323); // Clear all Bookmarks
editor.ExecuteCommandByID(4593); // Bookmark Changes
editor.ExecuteCommandByID(4590); // Extract Bookmarked Lines to New File
editor.ExecuteCommandByID (4497); // Reset Compare mode
}
567 Who developed the "avformat-59.dll" that comes with FFmpeg?
884 When building Fast API+Uvicorn environment with PyInstaller, console=False results in an error
566 rails db:create error: Could not find mysql2-0.5.4 in any of the sources
577 PHP ssh2_scp_send fails to send files as intended
606 Uncaught (inpromise) Error on Electron: An object could not be cloned
© 2024 OneMinuteCode. All rights reserved.