In Progress

Data Cleansing System

We have some large lists of telephone numbers that need cleansing. We need a tool/system that can be reused (even a simple excel spreadsheet would suffice) each time we have a new data set.

The cleansing process involves taking a list of telephone number prefixes (i.e. 07701, 07702) and running a list of data against the list of prefixes. Any telephone numbers that do not start with any of the same numbers as the prefix list should be removed. The end list should only include those numbers that start with the same numbers as the prefix list and should be formatted in a common way and easily exportable to .csv.

The bidder should have plenty of experience working with excel and/or building systems that are used for data cleansing.

Skills: Data Processing, Excel

See more: processing of data, data processing systems, data cleansing, data building, cleansing, telephone system, excel data csv, simple data spreadsheet, prefix set, excel data process, csv data process, excel spreadsheet set, simple system excel, excel simple system, csv data processing tool, excel large data, cleansing list, excel spreadsheet time, data process excel, time excel spreadsheet, telephone data, simple spreadsheet data, telephone process, system building, simple data process

About the Employer:
( 12 reviews ) Altrincham, United Kingdom

Project ID: #1328123

Awarded to:

bennieswart

Good day. I can deliver in a couple of hours after receiving the specifics. See PM for details. Regards, Bennie Swart.

$50 USD in 1 day
(1 Review)
1.4

21 freelancers are bidding on average $65 for this job

RSwapnil

I have good experience of excel macros. Please contact

$30 USD in 3 days
(54 Reviews)
5.5
nagybatonyi

I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering usual Open file dialog to identify the current inpu More

$50 USD in 2 days
(39 Reviews)
5.4
pyazlm

I have done similar projects and can provide a VBA appication with macros.

$30 USD in 2 days
(30 Reviews)
4.4
drobyshev

If you give me example of input data i can do demo right now.

$30 USD in 2 days
(5 Reviews)
4.3
shacoim

Hi, I have done several projects in Excel VBA automation works. Please check PM for more info.

$50 USD in 1 day
(11 Reviews)
3.9
gocean

Hi, we're data reorganization experts, and we can help with this. Please see PM for more details. Thanks.

$80 USD in 5 days
(10 Reviews)
3.8
ASFreelancer80

Hi, I am interested to work in this Data Cleansing Project. Have very good experience in Excel Formulas that can be used to cleanse huge volume of data. At the end of the project, I can be able to suggest the More

$30 USD in 1 day
(6 Reviews)
2.9
SVLakshmi

Sir, I have 12 years working experienced in two MNC companies in DATA CONVERSIONIST. I have working experienced in all types excel work like websearch, data mining, data extraction, data merging, form filling, proof More

$30 USD in 1 day
(4 Reviews)
3.0
Ishanka1505

Please see the PMB

$30 USD in 2 days
(4 Reviews)
2.2
Paranos

I am a US (Florida) based consultant with immediate availability to work on your project. I look forward to working with you on this project. See pm for details regards,Paranos.

$62 USD in 1 day
(1 Review)
2.1
BPINC

Dear Friend, Hope you are doing great! This is Aqeel Ahmed from Tech Bridge Consultancy (Virtual Services Provider). I welcome you to test our virtual services. Everything about our experience & past work related More

$30 USD in 3 days
(2 Reviews)
2.1
outcast1987

Hi, I can do this in two days. Try me. I have experience in excel, and I can provide you the results timely and accurately.

$30 USD in 2 days
(1 Review)
1.0
artwebsolutions

Should be easily done.

$50 USD in 2 days
(0 Reviews)
0.0
nagarajaks

I can do a neat job of this.

$45 USD in 4 days
(0 Reviews)
0.0
FeliuGroup

I am an experienced programmer and engineer and can develop your data cleansing program in Excel, Access, VB, Java, Android, Windows, etc. I will develop for you a tool that you will be able to use over and over to cle More

$250 USD in 20 days
(0 Reviews)
0.0
ImranJavd

I am a Software Engineer and I can easily do this project in 2-3 days.

$150 USD in 3 days
(0 Reviews)
0.0
tranngockien

I am really interested in this project. I have prior experiences regarding these kind of work.I strongly believe that I could fulfill all the requirements at work

$30 USD in 5 days
(0 Reviews)
0.0
jabedje

Sir, I am intrastate for your project I’m hard worker & reliable person You can trust me for your project . i try my best.

$200 USD in 5 days
(0 Reviews)
0.0
hivishy

this looks quite easy. m interested in doing it.

$60 USD in 1 day
(0 Reviews)
0.0
mightybichu

Hi, I have enough experience working with Excel and VBA macros for excel, with which this task could be completed. I will be able to provide you with a permanent solution for your issue. Cheers Mightybichu

$50 USD in 1 day
(0 Reviews)
0.0