Using sed or awk to filter a file

mitchell2345 · 04-09-2009, 10:00 PM

Hi,

I am using Mailman to create a mailing list for my company. Our membership database is stored in a MS SQL 2000 server. I have figuired out how to write a batch script to export my email address into a text file.

The file is formatted as so:

Code:

1> 2> 1> 2> 3> 4> 5> 6> 7> 8> 9>  email@dom.ain                           

 email@dom.ain

.... (many more email address, one every other line.)

 email@dom.ain

 email@dom.ain

(22529 rows affected)
1>

Mailman sync_members scripts needs only email address. How can i use sed and/or awk to filter this file and leave me with just the addresses.

i need a file with each email address, 1 per line. Blank lines are ok.

Thanks,
Mitchell

chrism01 · 04-10-2009, 12:10 AM

Code:

for rec in `cat t1.t`
do
    if [[ "$rec" =~ @ ]]
    then
        echo $rec
    fi
done

where t1.t contains your stuff above ....

mitchell2345 · 04-10-2009, 09:50 AM

Quote:

Originally Posted by chrism01

Code:

for rec in `cat t1.t`
do
    if [[ "$rec" =~ @ ]]
    then
        echo $rec
    fi
done

where t1.t contains your stuff above ....

Thanks for the reply. I cant seem to get this to work.

here is my simple bash script.

#input file
ifile=/mnt/sql/ome_output.txt

#output file
ofile=/scripts/ome_work.txt

Code:

#pull only emails out of input
for rec in $ifile
do
    if [[ "$rec" =~ @ ]]
    then
        echo $rec >> $ofile
    fi
done

I dont get anything in ome_work.txt when it runs. What am i missing?

thanks,
Mitchell

edit...
NVM! i took out the cat of `cat t1.t` durr.... added that back in and bingo. Thanks

ghostdog74 · 04-10-2009, 10:07 AM

Code:

# awk '{for(i=1;i<=NF;i++){if ($(i) ~ /@/) print $i}}' file
email@dom.ain
email@dom.ain
email@dom.ain
email@dom.ain