Google Docs Spreadsheet Formula Writing & Data Extraction

Admin Support Other - Admin Support Posted 2 years ago

Fixed Price

Delivery by February 8, 2013




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

Skills Required:

Client Activity on this Job

Last Viewed: 2 years ago

Proposals: 18

Hired: 1

About the Client

(4.82) 42 reviews

United States
Naples 03:35 AM

122 Jobs Posted
55% Hire Rate, 2 Open Jobs

Over $10,000 Total Spent
72 Hires, 17 Active

$7.05/hr Avg Hourly Rate Paid
1,158 Hours

Member Since Oct 20, 2008