Collect common words of two lists to a third list

Questions & Suggestions
1

I have two files (a.txt and b.txt) that have some words in common if you compare them case-insensitively:

Haus
Hund
bellen
Mist
schattig
Dusche
Wand

And:

huis
hond
bellen
mist
schattig
muur
wand
televisie

I'd like to create a third file (c.txt) that contains all words from file a.txt that appear (if case is ignored) in file b.txt:

Mist
schattig
bellen
Wand

Task: I'd like to create a list of all words from one language that also exist in another language (so-called homographs). The file a.txt will contain about 500,000 words.

Could somebody please help me with a script, or even a KM solution?

2

I think this macro I just posted should do the trick:

MACRO: Get Common Lines (Words) of Two Lists [Examples]

Example Output

image

Please let us know if this works for you, or you have related questions.

1 Like