ACT FAST! --- IMMEDIATE NEED - Transform some data (Program a simple script or do it manually)

  • Status: Closed
  • Hadiah: $50
  • Penyertaan diterima: 8
  • Pemenang: ugurbor

Keterangan Peraduan

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:
[url removed, login to view]

Spreadsheet 2:
[url removed, login to view]

So the script should replace "[url removed, login to view]" in spreadsheet 1 with "@[url removed, login to view]" in spreadsheet 1 so that "[url removed, login to view]" is transformed into "lincolnian@[url removed, login to view]"

Then I need the remainder fixed manually. The entire list is on the follwing site:

[url removed, login to view]

THE END RESULT WILL BE A LIST OF USABLE EMAIL ADDRESSES IN SPREADSHEET 1.

Kemahiran-kemahiran Cadangan

Maklum balas Majikan

“GREAT WORK! AND FAST TOO!”

Gambar Profil curatorseye, United States.

Penyertaan teratas dari peraduan ini

Lihat Penyertaan Lain

Papan Penerangan Awam

  • sultancontest
    sultancontest
    • 3 tahun yang lalu

    Freelancers have good news!!!!! www.SultanContest.com is a New Graphics Designing Contest Freelancing website, you can join free and get join all the contest and also you can post contest. If you are a good graphics designer, you can earn thousand of money... That is a great opportunity for freelancer and buyer..

    • 3 tahun yang lalu
  • ramyrafik
    ramyrafik
    • 3 tahun yang lalu

    I'm working on scraping the website and parsing email addresses instead of operating on the Excel sheet (which I can't find already). will send u complete list in 1 hour.

    • 3 tahun yang lalu
  • xiddw
    xiddw
    • 3 tahun yang lalu

    Please check my last entry.

    • 3 tahun yang lalu
  • MimiFL
    MimiFL
    • 3 tahun yang lalu

    Please check my entry!

    • 3 tahun yang lalu
  • expertatwork
    expertatwork
    • 3 tahun yang lalu

    Spreadsheet 2 does not have "aol.com" Please provide the updated sheet so that we can start right away

    • 3 tahun yang lalu
  • mindstrong
    mindstrong
    • 3 tahun yang lalu

    the two attached spreadsheet almost the same, both of them contain the emai address without "@" , a website list spreadsheet is acquired.

    • 3 tahun yang lalu
  • muhammadusmaneu
    muhammadusmaneu
    • 3 tahun yang lalu

    You should post this as a project , we will not work for free sorry . It is not logo that you are making it contest . It is serious project and our time is money .

    • 3 tahun yang lalu

Tunjukkan lebih banyak komen

Bagaimana mula dengan peraduan

  • Papar peraduan anda

    Papar Peraduan Anda Cepat dan senang

  • Dapatkan bertan-tan penyertaan

    Dapatkan Bertan-tan Penyertaan Dari seluruh dunia

  • Anugerahkan penyertaan terbaik

    Anugerahkan penyertaan terbaik Muat turun fail-fail - Senang!

Papar Peraduan Sekarang atau Sertai kami Hari Ini!