PrestoSoft Community

How to lookup 6 charactor of the left and replace row


File1
10002=:TEXT:Area
07B026=:LINE:07B:12:Continuous:0:21
07B024=:LINE:07B:12:Continuous:0:22
07B023=:LINE:07B:12:Continuous:0:23

File2
07B024=:LINE:07B:8:Continuous:0:25


After merge
10002=:TEXT:Area
07B026=:LINE:07B:12:Continuous:0:21
07B024=:LINE:07B:8:Continuous:0:25
07B023=:LINE:07B:12:Continuous:0:23

You actually can match lines starting with 07B024 -- by using Options | Compare | Ignore parts of each line | First/last... | Before: 0, After : 6. This, however, will make these lines "identical", and you'll have to merge manually, by typing or using Copy/Paste.