Google Docs Spreadsheet Formula Writing & Data Extraction

Admin Support Other - Admin Support Posted 3 years ago

Fixed Price

Delivery by February 8, 2013

$25

Budget

Details

I have 300,000 rows of data in about 10 spreadsheets.  Column A has a query string with about 20 values.  For each row, I need about 5 values extracted and put in columns on the same row (first name, last name, email address, phone number, etc).  Note: these spreadsheets are Google Docs, NOT Excel so please do NOT provide me with an Excel solution and tell me to make it work in Google Docs.  You must provide me with a Google Docs solution.

Below is an exerpt of the query string:
&alt_phone_country_code=1&event=submitInquiry&major_1_name=Music Production & Sound Design for Visual Media=&ppc_kywd=null&alt_phone_number=&phone_country_code=1&apartment_number=23&semester_name=Fall 2012&dob_day=24&phone_area_code=770

This should be a very very easy job for someone who knows excel well.  I'd like this done in the next few hours, so the first qualified person to respond will get the job.

---
Skills: design

  • Other Skills:

Activity on this Job

Last Viewed by Client: 3 years ago

Hired: 1

Other open jobs by this client ({{ jobsCount }})


About the Client

(4.85) 55 reviews

United States
Naples 12:06 PM

131 Jobs Posted
56% Hire Rate, 1 Open Job

Over $10,000 Total Spent
79 Hires, 8 Active

$7.24/hr Avg Hourly Rate Paid
1,203 Hours

Member Since Oct 20, 2008