Please help I have 2 columns and only need the hostname printed on a separate columns and then check duplicates between the 2 columns
Column A contains full domain names
11100011.com
11194.com
113dir.com
11dots.com
123greetinscard.com
other Column B contains entries like this
www.google.com
us.yahoo.com
www.facebook.com
Output columns should not contain any ".com",.uk and also no "www", etc at the beginning
so output must look
Column A
11100011
111941
123greetinscard
Column B
yahoo
Bookmarks