Devam Ediyor

.Net Desktop App using 2 Excel Files Read 1 Million Records

I need a software program in .NET C#, VB.NET)that works on xp, vista, or windows 7

This is a 6-8 hour job for an intermediate programmer.

---------------------------------------------------------------------

The software reads 10 digit numbers...matches them to a database and ads info from 2 excel columns to the original data if it matches.

For instance: This is what the checker file looks like.

Column A (about 173,000 lines always 3 digits)

333

444

555

666

Column B (about 173,000 lines always 3 digits)

545

343

323

121

Column C (about 173,000 lines if blank only match on column A and B only digits 0-9 or blank)

(some are blank)

5

(some are blank)

4

Column D (about 173,000 lines)

carried over data from match (if collumn A, B and C match number sequence data is carried over to new column B)

carried over data from match (if collumn A, B and C match number sequence data is carried over to new column B)

carried over data from match (if collumn A, B and C match number sequence data is carried over to new column B)

carried over data from match (if collumn A, B and C match number sequence data is carried over to new column B)

Column E (about 173,000 lines)

@additional carried data if match (data added to 10 digit number if match and placed in new column A)

@additional carried data if match (data added to 10 digit number if match and placed in new column A)

@additional carried data if match (data added to 10 digit number if match and placed in new column A)

@additional carried data if match (data added to 10 digit number if match and placed in new column A)

I need to take thousands if not hundreds of thousands of number sequences and run them through a checker that ads additional data to number sequences that match the data (173,000 checks).. Preferably these files will be all in excel. These sequences will all be variations of 10 digits but will include - symbols and ( ) symbols which will need to be automatically ignored. Also spaces will need to be ignored. I am just focusing on the first 7 digits in sequence in order of 3 (if valid continue match) then 3 (if valid continue match) then 1 (if valid first, second not valid complete match)

All sequences are variations of the style below, any sequence of numbers. (spaces, dashes and ( ) must be ignored. If it matches column A, then column B, then column C (if not match okay) data gets added to a new sheet including all remaining digits similar to what

is below:

Sample Data to be checked and matched:

333-343-5666 (matches with column A, B and C)

(444)-122-4784 (no match)

4557896454 (no match)

555 343 4556 (matches with column A, B and C)

6663236478 (matches with column A and B only which is still okay)

Attached to this checked and validated 10 digit code after dashes, spaces and ( ) are removed whatever is in column E is added to it without spaces in the new sheet for column A and new column B contains whatever is carried over from column D from the matched file like this:

New Column A (only matched files including all remaining digits)

3333435666@additional carried data if match

5553434556@additional carried data if match

6663236478@additional carried data if match

New Column B

carried over data from match

carried over data from match

carried over data from match.

It would need to query up to 1 Million records at a time in excel xlsx format cross referencing a database of 172,000 records.

Beceriler: .NET, ASP, C# Programlama, PHP, Yazılım Test Etme

Daha fazlasını görün: works need excel, vb programmer job, php programmer app, or desktop, net asp programmer, need of excel programmer, need an app programmer, need a c++ programmer for a job, job vb programmer, job vb.net, job vb net, job net programmer, job matches, intermediate excel, in need of app programmer, i need a vb net programmer, i need an app programmer, excel programmer job, excel for windows 8, d 555, asp net programmer job, app works, 3.1 .net, 1 hour job, read excel app net desktop

İşveren Hakkında:
( 1 değerlendirme ) Visalia, United States

Proje NO: #686839

Seçilen:

panfreelancer

Hi, I'm Pan. Please check pm. Thanks.

1 gün içinde 30$ USD
(27 Değerlendirme)
5.0

17 freelancers are bidding on average $99 for this job

vk15

Hi, ready to do. Please see your PM.

in 2 gün içinde120$ USD
(5 Değerlendirme)
4.4
umeshgohel2008

Hello Sir, Please check PMB, Thank you.

in 2 gün içinde100$ USD
(8 Değerlendirme)
4.1
yngautam

I am expert development of desktop application developer. I am easy way hand this kind of project and submit with in given period. any more pm Thanks

in 3 gün içinde150$ USD
(6 Değerlendirme)
3.6
A1bert

Please check your PMB.

1 gün içinde 70$ USD
(5 Değerlendirme)
3.5
Archit88

can do it man... BTW i compiled and test application on XP,VISTA and 7 both X86 and X32 ... hence no compatibility problems please mail me with some workable data so that i can show you demo Regards

in 5 gün içinde120$ USD
(9 Değerlendirme)
3.1
nSmartSolution

Hi, I have over 4 year experience in application development using .net technologies. You may check my profile for more details. Kindly check PMB one for project clarification. Thanks

in 2 gün içinde75$ USD
(1 Değerlendirme)
1.7
katmandu80

Hi I am C# coder. I already done similar projects with matching data between excel sheet and sql database. Best regards

in 3 gün içinde100$ USD
(0 Değerlendirme)
0.0
ipsiljammu

We have a 8 members team with good experience in .NET,PHP and [url removed, login to view] can do your project with in the [url removed, login to view] ready to take up your project immediately. So,please kindly send your confirmation message and also c Daha fazlası

in 10 gün içinde210$ USD
(0 Değerlendirme)
0.0
LionelG

Please see PMB for further information.

in 2 gün içinde120$ USD
(0 Değerlendirme)
0.0
Jia21

It is an easy project. Would be a C# project. Finish in 1 day.

1 gün içinde 50$ USD
(0 Değerlendirme)
0.0
sharphorse

Please check PM

in 3 gün içinde100$ USD
(0 Değerlendirme)
0.0
Majorchange2010

i can do it

in 2 gün içinde30$ USD
(0 Değerlendirme)
0.0
mohamedeldesoky

i have an experience with the office automation with .net technology and ready to work with this project. you don't have to pay until the project is done and you are totally satisfied.

in 0 gün içinde35$ USD
(0 Değerlendirme)
1.0
amarsrawat

Hello Sir/Madam, I am M.C.T.S in Certified in Windows®-Based Client Development. I can do this kind of projects easily.

in 2 gün içinde75$ USD
(0 Değerlendirme)
0.0
john007buc

I has done similar work in the past! So it will be an easy job for me!

in 3 gün içinde200$ USD
(0 Değerlendirme)
0.0
calingjoy

Hi, Worked in this kind of project and moreover I am an MCTS certified professional working in a very renowned company. Please ping me if interested. Regards, Joydeep

in 5 gün içinde100$ USD
(0 Değerlendirme)
0.0