CSV parser

Completed Posted Oct 3, 2013 Paid on delivery
Completed Paid on delivery

Objective is to parse three CSV files (ASR_STD, ASR_PRM and [login to view URL] - see link to archive below).

You would then match the country name in the first column (Destination) of the ASR_X files with the country_name column in the [login to view URL] file.

It will never be a full match as the "Destination" column in the ASR_X files will always contain additional information such as "Mobile", etc.

So the match would be for the left most characters.

You will then create a file like "[login to view URL]" for all matching entries - that means a country that appears in the [login to view URL] AND also in the ASR_X files. You would populate the "client_name" column in the "[login to view URL]" with the additional information from the "Destination" column of the ASR_X files. Please see the "[login to view URL]" for reference and please take note that data from the "ASR_PRM" will be of type "p" and data from ASR_STD" will be of type "w". Also please make sure that you will properly populate the country_id from the "[login to view URL]" file.

And please be aware the the input files could have different names. So you need to make sure that the user would upload / select the right file.

In addition to the "[login to view URL]" you would also create a second file "[login to view URL]" where you would populate all rows from the ASR_X files that NOT match with the "[login to view URL]".

The solution can be online running on either a .NET server or a Linux server (Apache based).

Or you can create a script or client application running on either Windows or Linux.

If you fail to start your bid with "Yes, I have" then it will be disregarded. You cannot believe how many bidders just bid without even reading the full project description.

Time is critical with this project so I can only accept bids where you will start right now and finish within the next 3-5 hours.

It's a fairly easy task after all. :)

Here are the files: [login to view URL]

.NET Java Perl PHP Python

Project ID: #4992488

About the project

8 proposals Remote project Active Oct 3, 2013

Awarded to:

rajeshsonisl

Hello, With 99% completion rate, 600 successfully completed projects, and a 5.00 reputation... you can never go wrong choosing me :) I look forward to your reply. Thanks. Kind Regards, Rajesh Soni

$78 USD in 1 day
(977 Reviews)
8.7

8 freelancers are bidding on average $135 for this job

vano101

:Looks like it's something easy for me. I'm going to use .NET in order to complete this task, I have experience with parsing CSV in .NET

$53 USD in 1 day
(1131 Reviews)
7.5
urmate

Contact me for an efficient solution within quickest possible time of 2-3 hours will start right away. Thanks

$103 USD in 0 days
(453 Reviews)
7.2
try67

Yes, I have read the description and I can do this for you quickly and professionally. I suggest to create a stand-alone Java application, which you could integrate into any other system you're using as it will be a c More

$166 USD in 1 day
(8 Reviews)
4.1
saifpia

Contact me I can provide a perfect, well documented solution within 3 hours. 100% accurate work. Thanks (Platform Choice: Java Any Version (GUI Based or Console). .Net Nay Version (C#, vb.net) GUI Based or Console, or More

$157 USD in 0 days
(2 Reviews)
1.2
kupilikl

"Yes, I have". I can do it, i'm going to use c#.. It is not problem. I can start now, if you choose me.

$222 USD in 0 days
(0 Reviews)
0.0
TypistHome

................................................................................................................................................................................

$155 USD in 3 days
(0 Reviews)
0.0