Google Docs Spreadsheet Formula Writing & Data Extraction

Admin Support Other - Admin Support Posted 3 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

  • Other Skills:

Activity on this Job

Last Viewed by Client: 3 years ago

Invites Sent: 0

Unanswered Invites: 0

Hired: 1

About the Client

(4.85) 58 reviews

United States
Naples 04:56 AM

135 Jobs Posted
57% Hire Rate, 1 Open Job

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

$7.45/hr Avg Hourly Rate Paid
1,256 Hours

Member Since Oct 20, 2008