On Sunday 03 Aug 2008, sampath wrote: > Hello friends > > I'm working an environment, where every day I need to split an > excel file which contains thousands of mobile numbers and send to all > the employees. Every day I'm doing this manually for nearly 50 > employees. So its painful and time consuming. Is there scripts to > split automatically and forward those to all. I'm working on Linux > machine(openSUSE 11), so please help me. >
Excel format is proprietary. Have you tried importing the sheet into OO Calc, sorting the data per your criteria, saving the result in CSV format and then parsing it with a script (gawk)? You can also try search CPAN (perl archive) to see if there any perl scripts that will do this for you. -- Arun Khan
