Reading data from file

[Osgar ali]

Hi,
I have this scenario, what is the best way to handle this.

I receive lots of files from different stores, which holds the store name, address, how can you find distinct addresses?

What if the same address is written in different forms (like more spaces added, lower cases, upper cases), then how can you find the distinct addresses?

Thanks
Oskar