Link to home
Get AccessLog in
Avatar of ddantes
ddantesFlag for United States of America

asked on

Extract domains from a text file

I'd like to extract a list of domains from a text file which includes Email addresses.   However, the objective is to list only the domains -- not complete Email addresses.  If there is a Windows-based application to perform this, please advise.
ASKER CERTIFIED SOLUTION
Avatar of Camy
Camy
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Avatar of ddantes

ASKER

Thank you.  I extracted all Email addresses from the text file into an Excel Worksheet.  I don't know how to perform the "text to columns" delimited by the @ sign which you specified.
In newer (2010 and 2013) versions of Excel it's on the data tab.
Select the column containing the email addresses, choose Data -> Text to Columns -> Delimited -> Next -> Other (@) -> Finish
Avatar of ddantes

ASKER

Sorry to say, I use Excel 2007.
SOLUTION
Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Avatar of ddantes

ASKER

Perfect.