You need to sign in to do that
Don't have an account?
Dilyan Dimitrov
How to normalize a large, user-generated data-set of company names
Hi,
I would like to know is there a way in salesforce to normalize a large, user-generated data-set of company names
We have user generated names of employers that come in all variations. For example
Google Google, Inc. Google Inc. Google inc
Does anyone have suggestions on how to normalize the existing entries, and also how to maintain we do it for all incoming names as well?
I would like to know is there a way in salesforce to normalize a large, user-generated data-set of company names
We have user generated names of employers that come in all variations. For example
Google Google, Inc. Google Inc. Google inc
Does anyone have suggestions on how to normalize the existing entries, and also how to maintain we do it for all incoming names as well?
Here is some psuedo-code that should point you in the right direction. I did not compile it or test it yet, so you will need to put it into a method, and you may need to tweak it. Also I cannot claim credit for the toProperCase method, I found that on a different thread (https://developer.salesforce.com/forums/?id=906F00000008ukJIAQ" target="_blank).
Hope that helps