Find Jobs
Hire Freelancers

Compare two CSV files, create diff CSV and sent report by mail

€8-30 EUR

Completed
Posted about 8 years ago

€8-30 EUR

Paid on delivery
Hello, I would like to request support for creating a Perl script that will: - compare two CSV files for a difference between two fields, and create a CSV file with differences - create and sent a html mail for reporting the differences Original file sizes: (example files attached) File1: around 60 KB File2: around 34 MB Required actions: - Script will read all records from [login to view URL], and check for matches between "model" and "ARTIKEL_ID" field from File2.csv. - The "model" field from [login to view URL] should be 6 characters/digits. (double quotes excluded) - If match is found, script will check the "price" field from [login to view URL] and compare this with the PRIJS_1 field from [login to view URL] (euro character/space from [login to view URL] should be ignored) - when price fields for a record are NOT matching, a line should be added to a [login to view URL] file in format: MODEL,PRIJS_1 (price from [login to view URL]), price (price from [login to view URL]) - Once all records have been verified, a report/mail should be created based on the records that were found with the script. (different prices). The report should contain the following data: MODEL (6 digits), OMSCHRIJVING (description from [login to view URL]), PRICE (from [login to view URL]), PRIJS_1 (From [login to view URL])
Project ID: 9720741

About the project

6 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello! I have good experience in perl. I can do this project. I will deliver you high quality code in due time.
€30 EUR in 1 day
4.9 (64 reviews)
5.6
5.6
6 freelancers are bidding on average €29 EUR for this job
User Avatar
Hello, I have many experience prepare text files with perl. I check your csv files and ready to srtart You want run via http or command line? Dmitry
€34 EUR in 3 days
5.0 (141 reviews)
6.2
6.2
User Avatar
A proposal has not yet been provided
€29 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have already experienced in perl for more than 5 years and I have already written these kind of script before.
€12 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
€34 EUR in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of NETHERLANDS
Rotterdam, Netherlands
5.0
5
Payment method verified
Member since Feb 21, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.