[SATLUG] Need scripting assistance

Brian Lewis astro at astr0.org
Fri Dec 21 22:56:11 CST 2007



> Scenario:
>
> A large (perhaps a 500MB) spreadsheet full of contacts. The info  
> contains an account number, first name, last name, email address.
>
> How would I go about extracting every email address from the  
> spreadsheet into a text file, on their own line ie.
>
> johndoe at foo.com
> janedoe at foo.com
> bob at foo.com
> etc etc
>
> Is this even possible?
>
> Even better,
> johndoe at foo.com; janedoe at foo.com; bob at foo.com
>
> In increments of about 200.
>
> Before anyone else asks, this is not for spam.. I would like to  
> contact all the customers in our system, and unfortunately, all the  
> data is in an excel spreadsheet :/ I don't really want to cp+p every  
> single address (well over 100,000) into emails. I would happily copy  
> and paste blocks of 200 :)
>
> Any advice would help!
>
> Thanks gang,
>
> Brian
>
> Not sent from my iphone, this one was sent using PINE (best email  
> client EVER)


More information about the SATLUG mailing list