ACT FAST! --- IMMEDIATE NEED - Transform some data (Program a simple script or do it manually)
- Status: Closed
- Prize: $50
- Entries Received: 8
- Winner: ugurbor
Contest Brief
NOTE: I will award the prize to the first person who creates the most complete list of approx 500 emails by November 20 10AM Eastern Standard Time. Or I will award it to the most complete list at the end date of the contest.
ACT FAST AND BE ACCURATE TO WIN!!!
I need someone to transform some data.
There are two sheets in the attached spreadsheet:
1) email addresses with the @ removed
2) websites that correspond to the emails
Because most of the emails have the same suffix (ie. after the @ sign) as the URL, I need someone to do the following.
Create a script that does a loop through spreadsheet 2 to go through all of the URLs in succession. In each loop, it should look up the URL in spreadsheet 1. Then it should replace any URL in spreadsheet 1 with @URL so that if creates a complete email address.
For example
Spreadsheet 1:
lincolnianaol.com
Spreadsheet 2:
aol.com
So the script should replace "aol.com" in spreadsheet 1 with "@aol.com" in spreadsheet 1 so that "lincolnianaol.com" is transformed into "lincolnian@aol.com"
Then I need the remainder fixed manually. The entire list is on the follwing site:
http://hq.abaa.org/books/antiquarian/databases/bookseller_search.html
THE END RESULT WILL BE A LIST OF USABLE EMAIL ADDRESSES IN SPREADSHEET 1.
Recommended Skills
Employer Feedback
“GREAT WORK! AND FAST TOO!”
curatorseye, United States.
Public Clarification Board
How to get started with contests
-
Post Your Contest Quick and easy
-
Get Tons of Entries From around the world
-
Award the best entry Download the files - Easy!