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

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

Ringkasan 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:
[login to view URL]

Spreadsheet 2:
[login to view URL]

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

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

[login to view URL]

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

Kemahiran Disyorkan

Maklum balas Majikan

“GREAT WORK! AND FAST TOO!”

Gambar Profil curatorseye, United States.

Penyertaan teratas dari peraduan ini

Lihat Lagi Entri

Papan Penjelasan Umum

  • sultancontest
    sultancontest
    • 4 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..

    • 4 tahun yang lalu
  • ramyrafik
    ramyrafik
    • 4 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.

    • 4 tahun yang lalu
  • xiddw
    xiddw
    • 4 tahun yang lalu

    Please check my last entry.

    • 4 tahun yang lalu
  • MimiFL
    MimiFL
    • 4 tahun yang lalu

    Please check my entry!

    • 4 tahun yang lalu
  • expertatwork
    expertatwork
    • 4 tahun yang lalu

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

    • 4 tahun yang lalu
  • mindstrong
    mindstrong
    • 4 tahun yang lalu

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

    • 4 tahun yang lalu
  • muhammadusmaneu
    muhammadusmaneu
    • 4 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 .

    • 4 tahun yang lalu

Tunjukkan lebih banyak komen

Bagaimana mula dengan peraduan

  • Paparkan peraduan anda

    Paparkan Peraduan Anda Cepat dan mudah

  • Dapatkan berjuta penyertaan

    Dapatkan Bertan-tan Penyertaan Dari serata dunia

  • Anugerahkan penyertaan terbaik

    Anugerahkan penyertaan terbaik Muat turun fail-fail - Mudah!

Paparkan Peraduan Sekarang atau Sertai kami Hari Ini!