[SATLUG] Need scripting assistance

Charles Hogan cd_satl at futuretechsolutions.com
Fri Dec 21 23:32:22 CST 2007


There are several perl modules form parsing/converting excel files. 
Perhaps something in there could be of use.

http://search.cpan.org/search?query=excel&mode=all

Brian Lewis wrote:
> 
> 
>> 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