Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
neeraj1401
Starting Member
36 Posts |
 Posted - 2009-01-22 : 07:07:57
|
| Hi, I have to two tables, Customer data and City master. In city master there is field C_city, I have to clean the data of c_city, I'm mapping the city with city master. I'm facing the problem with cities having speliing mistake. is there any procedure which help me to clean the data. Thanks in Advance. |
|
|
raky
Aged Yak Warrior
767 Posts |
Posted - 2009-01-22 : 07:26:11
|
quote:
Originally posted by neeraj1401
Hi, I have to two tables, Customer data and City master. In city master there is field C_city, I have to clean the data of c_city, I'm mapping the city with city master. I'm facing the problem with cities having speliing mistake. is there any procedure which help me to clean the data. Thanks in Advance.
Just add another column for temporary purpose and move the data in c_city to new column and update the data in c_city with null value and correct the data (spelling mistakes ) in new column and later on update the data in old column c_city with your new column |
 |
|
|
neeraj1401
Starting Member
36 Posts |
Posted - 2009-01-22 : 07:32:31
|
Thanks Raky. I'm working with large data so mannal cleaning is litile difficult . Is there any function like soundex ....please sugesstsquote:
Originally posted by raky
quote:
Originally posted by neeraj1401
Hi, I have to two tables, Customer data and City master. In city master there is field C_city, I have to clean the data of c_city, I'm mapping the city with city master. I'm facing the problem with cities having speliing mistake. is there any procedure which help me to clean the data. Thanks in Advance.
Just add another column for temporary purpose and move the data in c_city to new column and update the data in c_city with null value and correct the data (spelling mistakes ) in new column and later on update the data in new column with your old column c_city...
|
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2009-01-22 : 07:51:01
|
| You can use either Soundex() or Difference(), but on large data set this will be really slow.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
neeraj1401
Starting Member
36 Posts |
|
|
|
|
|
|
|
Data Cleaning