How to find duplicates in two different tables

edvard_korsbaek · PostNov 25, 2024#12024-11-25T09:55+00:00

I need to find duplicates in two different XML files named table6.xml and table32.xml.

table6.xml has a line:

Code: Select all

<c1>6932</c1>

table32.xml has this line

Code: Select all

<c12>6442</c12>

I want to know if 6932 exists in both files.

I know that there are 124 duplicates.

How to?

I tried to upload the two files, but they were rejected.

Best regards

Edvard Korsbæk

Mofi · PostNov 25, 2024#22024-11-25T18:47+00:00

There are a lots of scripts and macros posted for finding duplicate lines of two files or the opposite finding unique lines of two files, see the results of the advanced forum search +duplicate* +file* in the macros and scripts forums.

If the forum prevents uploading *.xml files, compress both into a 7-Zip (*.7z), RAR (*.rar) or ZIP (*.zip) archive file and attach the archive file to the post.

edvard_korsbaek · PostNov 26, 2024#32024-11-26T10:12+00:00

Dear Mofi!

I ended up by using ChatGTP to make this script in PowerShell. I am 79 years old, and to lean another programming language is perhaps a bit late.

Code: Select all

# Filepaths
$file1 = "d:\ada\roenberg\table6.xml"
$file2 = "d:\ada\roenberg\table32.xml"

# Read the content of the XML-files
[xml]$xml1 = Get-Content $file1
[xml]$xml2 = Get-Content $file2

# Get values from the specifikke tags
$c1Numbers = $xml1.SelectNodes("//c1") | ForEach-Object { $_.InnerText }
write-output "tabel6:  $c1Numbers"
$c12Numbers = $xml2.SelectNodes("//row/c12") | ForEach-Object { $_.InnerText }
write-output "tabel32:  $c12Numbers"
# Find duplicates
$commonNumbers = $c1Numbers | Where-Object { $c12Numbers -contains $_ }

# Write out.
Write-Output "Fælles numre: $($commonNumbers.Count)"
$commonNumbers | Sort-Object