158250 scripts to scrub .csv file


I have a .csv file that my company provides to me on a weekly basis. The first 2 columns in this .csv are the most important to me. There can be anywhere from 500 to 70,000 records at one time.

Column one is always domains. Example format: [url removed, login to view]

Column two is always email addresses.

I need scripts that will remove information that is not important to me.

First: There is always a domain in the first column, but the second column is sometimes empty. When this happends, delete the row and write these domains from column 1 to a new file

Second: I will provide a list of words in a file, and I will need the script to compare this list of words to the second column in .csv (the email address column). If any these words are found in any of the email addresses, these records should be removed from the .csv. The script should save all of the deleted rows in a new file.

Third: Often, the second column in the .csv (email addresses) will have more than one email address. I'm only interested in the first email address, so the script should remove all of the extra email addresses.

This can be one script that does all of this, or 3 different scripts. Either way, it's pretty simple and shouldn't take long to write.

Looking forward to your bids, thanks!

Compétences : Tout va bien, Delphi, Java, Perl, PHP, Visual Basic

en voir plus : scrub csv file, simple scripts, email list scrub, simple csv, csv file, php file remove, php remove file, csv column format, write script file, simple csv perl script, records domain, extra email, 500 words domain, important file, compare save, save email file, script delete row php, php csv compare, deleted domains, write file

Concernant l'employeur :
( 27 commentaires ) Princeton Junction, Israel

Nº du projet : #1904438

Décerné à:

                                                's Profile Picture"                                                    >
                                        <div class=

Please see the PMB

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(43 Commentaires)