Sedang Disiapkan

bash scripting using 'sed' or 'rpl'

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

# ----------------------------------------

[url removed, login to view]

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

,,,,,,,/[url removed, login to view],3

,,,,,,,/[url removed, login to view],1

,,,,,,,/[url removed, login to view],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.

Kemahiran: Pemprosesan Data, Linux, Memasang Skrip

Lihat lebih lanjut: rpl bash, rpl sed, bash rpl, scripting sed, using sed bash script, linux rpl example, using linux rpl, bash scripting sed, bash sed csv, bash sed example, sed bash, sed bash script, bash sed, rpl linux, sed rpl, bash process csv, bash sed examples, linux using sed bash script, bash log parser, sed scripting, www seeks com, www seeks, www referral code, seeks com, seeks

Tentang Majikan:
( 34 ulasan ) Toronto, Canada

ID Projek: #342812