Data Cleaning:
Where different members of staff or unknown web users submit data to be stored
on your database, each person will use their own capitalisations and styles
of writing details such as postcodes, phone numbers and addresses etc.
We can clean up your existing databases so they adhere to a common format.
We can also provide scripts that error check and automatically convert new
data being input to your chosen style to ensure it adheres to the common format
you decide upon:
For Example, Before conversion this address could have been submitted in the
following ways:
|
Before Conversion:
www.3ps.co.uk
3ps computer services
rockfield hse
10 dannyboy place
limavady
bt490uh
(028) 7776 7850 |
Before Conversion:
http://www.3ps.co.uk
3PS COMPUTER SERVICES
ROCKFIELD HSE
10DANNYBOY PL
LIMAVADY
BT49 0UH
0044 2877 767850
|
Before Conversion:
www.3ps.co,.uk
3PS Computer Services
Rockfield House
10 DannyBoy Pl
Limavady
BT49 0UH
Tel 028-77767850 |
| After Conversion:
http://www.3ps.co.uk
3PS Computer Services
Rockfield House
10 DannyBoy Place
Limavady
BT49 0UH
Tel 028 7776 7850 |
After Conversion:
http://www.3ps.co.uk
3PS Computer Services
Rockfield House
10 DannyBoy Place
Limavady
BT49 0UH
Tel 028 7776 7850 |
After Conversion:
http://www.3ps.co.uk
3PS Computer Services
Rockfield House
10 DannyBoy Place
Limavady
BT49 0UH
Tel 028 7776 7850 |
Other features can include checking that e-mail & web addresses are valid.
|