Compare two files then add below same line number

Question

1.00/5 (1 vote)

See more:

How to combine command diff with sed (or other commands) to solve this question?

FileRemote includes new lines that will be added to FileLocal in specific places.

FileRemote:

## Functions
Read Auto Hide List #101
Read Auto Move Win #102
# Read Yad Position #103
# Read Tiling Function #104 

## Styles
Read Fvwm Thumbnails #201
# Read Diary Thumbnails #202
Read MyBorder Style #203

## Menus
Read MyMenu #301
# Read Flat Menu #302

FileLocal:

## Functions
Read Auto Hide List #101
# Read Auto Move Win #102

## Styles
# Read Fvwm Thumbnails #201
Read Diary Thumbnails #202
# Read MyBorder Style #203

## Menus
Read MyMenu #301

1. Compare the two files. The main difference is the three lines (#103, #104, #302) in FileRemote.
2. Copy only the three lines to FileLocal respectively. For example, lines #103 and #104 will be added below line #102 in FileLocal. And #302 under #301.

As the result, to copy only the numeric tags from FileRemote that do not exist in FileLocal, and preserve the order.

RESULT (FileLocal):

## Functions
Read Auto Hide List #101
# Read Auto Move Win #102
# Read Yad Position #103
# Read Tiling Function #104 

## Styles
# Read Fvwm Thumbnails #201
Read Diary Thumbnails #202
# Read MyBorder Style #203

## Menus
Read MyMenu #301
# Read Flat Menu #302

What I have tried:

I tried diff command with different options but creates duplicate lines due to the difference with the 1st column "#". How to combine with sed or other commands? The line numbers (#101, #102, etc.) are unique in both files.

Thank you in advance.

Posted 21-Mar-22 8:43am

RasatPC

Updated 21-Mar-22 10:51am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Luc Pattyn · Answer 1 · 2022-03-21T10:51:00

Solution 1

Maybe this article is a good starting point: LPTextFileDiff: another textfile compare utility.[^]

:)

Posted 21-Mar-22 10:51am

Luc Pattyn

RasatPC · Answer 2 · 2022-03-22T11:11:00

Got the solution that works but is clumsy.

awk '{print $1 " " $(NF)}' FileLocal.txt > output.tmp
grep '^Read' output.tmp > output2.tmp

Output2.tmp (result):

Read #101
Read #202
Read #301

sed -i 's/Read/# Read/g' FileRemote.txt
sed -i 's/# # Read/# Read/g' FileRemote.txt

FileRemote.txt (result, all lines are tagged with "#")

Quote:
## Functions
# Read Auto Hide List #101
# Read Auto Move Win #102
# Read Yad Position #103
# Read Tiling Function #104

## Styles
# Read Fvwm Thumbnails #201
# Read Diary Thumbnails #202
# Read MyBorder Style #203

## Menus
# Read MyMenu #301
# Read Flat Menu #302

awk '                                       
NR==FNR {a[$2] = $1; next}
$(NF) in a {$1 = a[$(NF)]}
1' output2.tmp FileRemote.txt > Result.txt

$ sed -i 's/Read Read/Read/g' Result.txt

RESULT same as my opening question.

If there is a better code, I appreciate the help. The solution is for public usage.