Extract email addresses from big file.

**superc0red** · 05-17-2007

Hey.

I have a big text file with data,
and i want to extract mail addresses.

How i can do it?

**ghostdog74** · 05-17-2007

you can use tools like awk/sed/perl/python etc...
show sample of the file and your expected output.

**superc0red** · 05-17-2007

It is a text file with random data inside.

example :
---------------------------------------------------
adfadf dfa asgasagf koko@yahoo.com adfga asdfa aa
sd asdf aazs dump@mail.com adfgf asdff asdfas
sdf sg afdgag rgteggsadf gdfg sdfgsd sdfg sdfgs dfgds
sdfgsd sdgsfg sdfgsf sdfgsf s pips@hotmail.com
ad adfa #4t346 n5635
--------------------------------------------------

**drl** · 05-17-2007

Hi.

I augmented your data file:

Code:

% cat data1
adfadf dfa asgasagf koko@yahoo.com adfga asdfa aa
sd asdf aazs dump@mail.com adfgf asdff asdfas
sdf sg afdgag rgteggsadf gdfg sdfgsd sdfg sdfgs dfgds
sdfgsd sdgsfg sdfgsf sdfgsf s pips@hotmail.com
ad adfa #4t346 n5635
ad adfa #4t346 n5635 c@c.com o@o.org g@g.gov xxyyzz
ad sdfg only-address@  @no-name.com lkjh

Then ran this script:

Code:

#!/bin/sh

# @(#) s1       Demonstrate regular expression for email address.

FILE=${1-data1}

grep --only-matching -E '[.[:alnum:]]+@[.[:alnum:]]+' $FILE

To get this:

Code:

% ./s1
koko@yahoo.com
dump@mail.com
pips@hotmail.com
c@c.com
o@o.org
g@g.gov

For a good first approximation ... cheers, drl

**ghostdog74** · 05-17-2007

Code:

awk '
{
  for (i=1;i<=NF;i++) {
       if ( $i ~ /[[:alpha:]]@[[:alpha:]]/ )  { 
	  print $i      
       }
  }
}' "file"

**drl** · 05-18-2007

Hi.

The awk script from ghostdog74 inspired me to simplify the solution:

Code:

#!/bin/sh

# @(#) s5       Demonstrate most simple regular expression for email address.

FILE=${1-data1}

tr ' ' '\n' <$FILE |
grep '@'

Run on data file:

Code:

adfadf dfa asgasagf koko@yahoo.com adfga asdfa aa
sd asdf aazs dump@mail.com adfgf asdff asdfas
sdf sg afdgag rgteggsadf gdfg sdfgsd sdfg sdfgs dfgds
sdfgsd sdgsfg sdfgsf sdfgsf s pips@hotmail.com
ad adfa #4t346 n5635
ad adfa #4t346 n5635 c@c.com o@o.org g@g.gov xxyyzz
ad sdfg only-address@  @no-name.com lkjh
sdfg wacko-one@msu.edu trendnet polk271.sam@fiddlehead.com
fdsa wizard4@future.com  lucky@911.org

To produce:

Code:

% ./s5
koko@yahoo.com
dump@mail.com
pips@hotmail.com
c@c.com
o@o.org
g@g.gov
only-address@
@no-name.com
wacko-one@msu.edu
polk271.sam@fiddlehead.com
wizard4@future.com
lucky@911.org

And from there you can filter bad addresses if you have them ... cheers, drl

**superc0red** · 05-18-2007

thanx for help dudes

Thread Tools

Display

Extract email addresses from big file.

Posting Permissions