Færdiggjort

Cross reference two files *SIMPLE PROJECT*

Hello Coders,

I need a program which will cross reference two files (one in csv format and one in tab delimited text format) to filter out the results. I have attached samples of both files. The program will take each value from column "SKU" of txt file and search for it in column "upc" of csv file. If the value is not found, then remove the entire row containing that value from txt file and put it in a new file in xls format called "not found". If the value from column "SKU" of txt file is found in column "upc" of csv file then check its corresponding value in column "sale-price" of csv file and compare it with the value in column "Price" of txt file. Make sure that both values should be exactly the same. If the values are not same then update the value in column "Price" of txt file as per value in column "sale-price" of csv file.

For example, the first value in the "SKU" column of the attached [url removed, login to view] file is 634991141925. Search for the value 634991141925 in column "upc" of the attached sample file data.csv. Let's suppose that this value is not found. Therefore remove the entire row containing the value 634991141925 from [url removed, login to view] file and put it in a new xls file called "[url removed, login to view]". Make sure to use the header in the "[url removed, login to view]" file as shown in [url removed, login to view] file.

However, since the value 634991141925 is found in column "upc" of the attached [url removed, login to view] file, take the corresponding value from column "sale-price" of [url removed, login to view] and compare it with the value in column "Price" of biz.txt. If the values are same then no change is required. If the values are not same then update the value in column "Price" of [url removed, login to view] as per value in column "sale-price" of data.csv.

It's a very simple project if you carefully read the description and understand the example. It would be great if you can show me a demo so I can immediately select your bid.

Thank you.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

windows xp

Evner: C programmering, PHP

Se mere: xls header, work reference, sample project agreement, project agreement sample, c programming reference, coders for hire run your project, simple web site demo in php, simple project work, search for files, reference , cross work, upc php, tab delimited text, windows compare file, tab delimited format, csv column format, files sale, program simple project, php text xls, upc example code

Om arbejdsgiveren:
( 199 bedømmelser ) fontana, United States

Projekt ID: #3331825

Tildelt til:

bob1982

See private message.

$7 USD in 2 dage
(382 bedømmelser)
6.9

8 freelancere byder i gennemsnit $7 på dette job

Premshanks

See private message.

$6.8 USD in 2 dage
(355 bedømmelser)
6.5
mihaimaris

See private message.

$4.25 USD in 2 dage
(47 bedømmelser)
5.3
teddybool

See private message.

$8.5 USD in 2 dage
(50 bedømmelser)
5.1
KostaShah

See private message.

$8.5 USD in 2 dage
(37 bedømmelser)
4.8
eisoftserv

See private message.

$8.5 USD in 2 dage
(2 bedømmelser)
0.6
mu

See private message.

$8.5 USD in 2 dage
(1 bedømmelse)
0.8
rocktallica

See private message.

$8.5 USD in 2 dage
(0 bedømmelser)
0.0
chrisellissl

See private message.

$4.25 USD in 2 dage
(0 bedømmelser)
0.0