Perl script to process a csv file and generate a change report

In Progress

I generate a csv file weekly and I would like to compare the new file with the previous file and generate a report. I know that diff and join can do some of this, but what I want is for the script to be able to take command line options that allow me to specify which columns from each file I want to compare and the other columns are ignored. The key to join both files will be a standardized domain name. Each file will have a header row with field descriptors. File sizes can range from thousands to hundreds of thousands of rows. The report would show changes in the columns specified from one file to the other. The script would also allow changes detected to be limited to a specific list of keywords and other changes found would not be reported. If no keyword list is indicated, then all changes in specified columns would be reported on.

Report details would include:

File Names (1st and 2nd)

DateStamp at time of report generation

Row counts for both files

Field Descriptors selected for change report

Total # of changes detected

Limit report to selected keywords:

Then list of the actual changes in a pipe delimited output file. If there are multiple changes found for a single domain, then each change gets it's own row and the domain is printed each time. So the report would look like:

Domain File1_webserver File2_webserver

[url removed, login to view] apache IIS

I look forward to hearing from you.

Skills: Perl

See more: perl diff csv, perl compare csv, perl script generate csv file, perl change file, printed names, names generation, weekly limit, key generate, csv file, change selected, perl keyword, perl script file, selected process, process iis, domain name change, names change, iis domain, line csv, will process csv, keyword csv files, perl change header csv file, csv generate, perl output, join file, csv pipe delimited

About the Employer:
( 192 reviews ) Vancouver, United States

Project ID: #4490954

Awarded to:

gangabass

I'm the best Perl developer here that's why I'm sure you'll be impressed with my work. See PM for details.

$123 USD in 1 day
(136 Reviews)
5.8

11 freelancers are bidding on average $136 for this job

lepoitr

I'm interested in that project. I'm experienced (15+) perl developer and linux administrator. I've made few similar scripts here as freelancer projects.

$147 USD in 1 day
(8 Reviews)
4.9
techvolcano

Ready to start

$105 USD in 4 days
(18 Reviews)
4.0
pablotorres

i can do it

$154 USD in 14 days
(4 Reviews)
2.2
arunragini

Please check your mail.

$149 USD in 5 days
(2 Reviews)
1.9
paymahn

Your project sounds interesting and very straight forward. I am looking forward to helping you out with this.

$99 USD in 3 days
(1 Review)
1.0
samorrisvw

Happy to help, this is a very straight-forward script to write. I've included my proposal in a private message. cheers -- Scott

$154 USD in 3 days
(0 Reviews)
0.0
freelancermartin

Hi, I am a perl developer with experience in processing files.Please see the PM for this bid Thank you.

$220 USD in 3 days
(0 Reviews)
0.0
sebastientorres

Hi, I've sent you a Private Message with details.

$132 USD in 4 days
(0 Reviews)
0.0
nitin62002

Best work is guaranteed. Please check PM.

$99 USD in 4 days
(0 Reviews)
0.0
JanuR08

Am a fresher freelancer here. This is my first job. So I swear I will do my best to prove myself.

$110 USD in 3 days
(0 Reviews)
0.0