Find Jobs
Hire Freelancers

Create software to remove duplicate emails, tidy formatting and other tasks

£250-750 GBP

In Progress
Posted about 9 years ago

£250-750 GBP

Paid on delivery
General information for the business: We are an advertising agency with a very large B2B database Database management system (DBMS): Microsoft SQL Server Description of requirements/functionality: Create software to allow us to load a csv file into the software which runs against our master file of email addresses and removes any duplicates, sort of the case on type, extract first names from email addresses etc. We get data from different sources and as so the requirements are slightly different for each one so might need to be able to select different actions based on the list type or select certain stages that apply to that list. Here are some of the processes involved: - Deduplicate on email address - We extract any first names from email addresses and populate a Salutation filed - Where a Company Name field is blank we create one from the Website field by removing “www.” and “.[login to view URL]” and captialising the first letter of the remaining url. - We like to have remove any ltd, plc etc removed from company names. - Ensure all fields are in the proper case. For instance no company names input as all capital letters. - Remove any “role based” email addresses such as admin@ or customercomplaints@ etc We would like to make this as portable as possible so that if we need to run the software on a different computer it isn't too much hassle to set up. THIS PROJECT IS LISTED AS BEING £250 - £750 BUT WE DO NOT WANT TO SPEND MORE THAN £300 ( $450).
Project ID: 7410364

About the project

11 proposals
Remote project
Active 9 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
11 freelancers are bidding on average £275 GBP for this job
User Avatar
Hello I can build this within 2 days Demo After 1 Day And after 2nd day Final Product Can i see your sample csv ? On which OS you will run this ? Windows ? Linux ? Mac ? Let me know, i can do for all of them Waiting for your response Thanks
£250 GBP in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello sir/madam, However, I am new here in freelancer.com I have over 10 years of experience in .Net and VBA programming. I can write for you such a tool using C#. Also I can recommend you usage of Excel add-ins, so your users will work in traditional Excel and perform your. I am ready to start doing your job right now and provide you some results by end of this date. Please contact me to discuss the details. Waiting for your messages. Thanks in advance. Best regards, Tolib Rahimov
£250 GBP in 3 days
4.9 (7 reviews)
0.0
0.0
User Avatar
Hello I am Java expert and interested in this project. I have reviewed your requirements and confident to handle this project perfectly. I suggest a Java desktop application with an simple gui for your project. Please communicate to discuss further. Regards Anshu
£300 GBP in 7 days
4.6 (7 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
£305 GBP in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello employer, I'm real person, and not a bot like indians... Please check my rate & feedback ;) 12 years of experience in Delphi, i can the app(exe) which will run in all pc with windows. Please contact me to to discuss about the project. Thank you! Best Regards.
£277 GBP in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I've done this job many times before and i think i can handle this one easily. I am planning to make an asp.net website for this and you'll be able to use it from any device with a browser. Also i'll share the source code with you.
£250 GBP in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Sir/Madam I have solid experience as Oracle, SQL Server and Sybase, PostgreSQL DBA. I am SQL server certified DBA in both as DBA and Design. I worked as DBA in USA for 13 years. I came back recently to start my own work. I have a number of excellent reference as DBA, Architect and Modeler. Please take a look at my resume and you will find that I am the best fit for this job. I have just completed couple of projects on database and the clients were from Australia and Canada. Currently I am working on a USA project Please see the review. Please look at my approach sir, 1. Will create a table based on the excel/flat file 2. Will import the raw data into this table (may be bcp in) 3. Will write a stored procedure to take care all the refinement of data by looping through one row at a time. 4. Will prepare the data in this table for final destination. 5. Write sql to populate the unique data into final table. 6. We will run a batch file to execute the above above code. So you have to port 1. batch, 1 stored procedureand and a table. Thanks Appreciate your kind attention in this regard, Warm regards,
£251 GBP in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I suggest portable, cross-platform software written in Python. The software will be managed with configuration file and provide fast processing. Best regards,
£250 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Experience 15 years SQL SERVER + VB6/VB.NET; Familiar with writing advanced complex filtering queries;
£300 GBP in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Peterborough, United Kingdom
5.0
60
Payment method verified
Member since May 7, 2014

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.