Canadian company seeks programmer/shell scripter to provide a simple script which will parse the contents of six small CSV files and output one new CSV file containing selective results. sample source files:
*********** Sample 1:
"# ----------------------------------------",,,
"www.website.com",,,
"Traffic Sources Overview",,,
01/11/08,11/11/08,,
"# ----------------------------------------",,,
,,,
"# ----------------------------------------",,,
"# Graph",,,
"# ----------------------------------------",,,
"Day","Visits",,
01/11/08,89,,
02/11/08,137,,
03/11/08,200,,
04/11/08,160,,
05/11/08,81,,
06/11/08,59,,
07/11/08,136,,
08/11/08,59,,
09/11/08,90,,
10/11/08,76,,
11/11/08,72,,
,,,
"# ----------------------------------------",,,
"# Pie",,,
"# ----------------------------------------",,,
"Referring Sites","Direct Traffic","Search Engines","Other"
544,310,294,11
0.47,0.27,0.25,0.01
,,,
"# ----------------------------------------",,,
"# SourceMiniTable",,,
"# ----------------------------------------",,,
"Sources","Visits","% visits",
"(direct) ((none))",310,0.27,
"google (cpc)",191,0.16,
"referral site 1 (referral)",102,0.09,
"google (organic)",89,0.08,
"referral site 2 (referral)",18,0.02,
,,,
"# ----------------------------------------",,,
"# KeywordMiniTable",,,
"# ----------------------------------------",,,
"Keywords","Visits","% visits",
"keyword 1",123,0.42,
"keyword 1",35,0.12,
"keyword 1",20,0.07,
"keyword 1",17,0.06,
"keyword 1",17,0.06,
"# --------------------------------------------------------------------------------",,,
************* Sample 2
# ----------------------------------------
[login to view URL]
Goal Funnel,
"November 1, 2008","November 11, 2008"
# ----------------------------------------
# ----------------------------------------
# Graph
# ----------------------------------------
Day,Goal3 Conversion Rate
"November 1, 2008",1.12%
"November 2, 2008",0.73%
"November 3, 2008",0.50%
"November 4, 2008",3.12%
"November 5, 2008",3.70%
"November 6, 2008",6.78%
"November 7, 2008",2.94%
"November 8, 2008",0.00%
"November 9, 2008",2.22%
"November 10, 2008",2.63%
"November 11, 2008",8.33%
# ----------------------------------------
# GoalFunnel
# ----------------------------------------
,18,,PH,18,4,,,14
(entrance),18,,,,,,(exit),9
,,,,,,,/[login to view URL],3
,,,,,,,/[login to view URL],1
,,,,,,,/[login to view URL],1
,0,,label,4,
# --------------------------------------------------------------------------------
As an example, in Sample 1 we would be looking to strip out all of the content except for the 6 lines inside of the Source Mini Table section, and in Sample 2 we would be looking for only the first line in the section Goal funnel. New titles/section markers will need to be input into the output file.
All source files will be submitted to bidders who can provide references for similar work so that they can assess time required for the project and to set a budget.
Code must be simple, well commented and run in a linux bash environment using 'sed' or 'rpl'.
Thanks, and happy bidding.