Content List (Regular Expression, Screen Scrape, Excel)
$10-30 USD
Paid on delivery
Bids should be 30-40 dollars.
I have a list of of ~10,000 rows in a Google Doc Spreadsheet with the following columns:
- Channel
- Page URL
- Visitors
- Visits
- Views
- Metrics Date Range
- Title
- Publishing Date
- Content Type
- Alignment
- Category
1 ) If the Channel is [url removed, login to view]
I need a script (preferably that can run in Google Docs or Excel) to use the Page URL from the spreadsheet, and pull the Title, Category information from this webpage [url removed, login to view]
For example, if the page URL was [url removed, login to view] - the title would be WebEx Cloud Connected Audio
The Categories would then need to match up
Website Categories > Spreadsheet Categories
- Borderless Networks > Enterprise Networks / BYOD / Mobility
- Business of IT > Business of IT / ITaaS
- Data Center > Data Center / Cloud
- Collaboration > Collaboration / UC / Video
From there the Alignment would need to match up
Spreadsheet Category > Alignment
Enterprise Networks / BYOD / Mobility > Leadership in the Core
Business of IT / ITaaS > Other
Collaboration / UC / Video > Collaboration
Data Center / Cloud > Data Center
SDN > Leadership in the Core
Security > Other
2) If the Channel is Blog
I need a script that can run in Google Docs or Excel that will use the Page URL information, and scrape the title.
For example, if the page URL was:
[url removed, login to view]
The title would be: The Road to Unified Communications – Flexibility, Mobility, Simplicity
Project ID: #5309732
About the project
10 freelancers are bidding on average $35 for this job
HI Naroni. Could you please send me the spreadsheet once so i could run my tools and see if I can provide the required data that you want. You can give me the project once i give you the confirmation that my tool has p More
I have examined your requirements and may be suitable to conduct the job. I am ready to start the job. I can send work samples if need. I expect your PM to discuss more details
Simple VBA script calling DOM objects in internet explorer. I already have a macro that does something more complicated. I could simplify it an get it back to you no problem.
I am a PHP developer. I am very very good at Regular expression. I can do this project. I can show you the sample to prove my ability. Thank you!
We are professional and provide a professional service for professional people and with 0% margin of error please try us and you will not regret Thanks