[SOLVED] Email account file (need help sorting it out)

rhbegin · 05-03-2011, 12:51 PM

I have a text file called active.txt from our Linux server.

The format is as follows:

aabonner@xanco.com,0,
aagiang@xanco.com,2,
aalfaro@xanco.com,2,
aandirene@xanco.com,0,

The '0' by the email address means an active account the '2' means inactive email account.

How can I sort this file and just leave the active accounts with a '0' but have it formatted like this:

aabonner@xanco.com
aandirene@xanco.com

I do not need the (,0,) on the end since I am putting this in a database for the email server to query.

Any help would be great.

thanks

winning · 05-03-2011, 02:00 PM

Something like..

Code:

grep ',0,' ADDRESSES | cut -d',' -f1

perhaps?

rhbegin · 05-03-2011, 03:20 PM

Quote:

Originally Posted by winning

Something like..

Code:

grep ',0,' ADDRESSES | cut -d',' -f1

perhaps?

That works!

Thanks a million!

rhbegin · 05-03-2011, 08:54 PM

Do you know of any good books that will give a foundation of bash scripting that you can build on.

This is my weakest area of all, I have not grasped the concept or fundamentals.

Any advice/help would be great.