You need to sign in to do that
Don't have an account?
carramrod
Field update to Proper Case.
I'm trying to do a field update to proper case, and since there isn't any propercase function in the formula editor, i'm kind of at a loss.
I want to take 123 EASY sT. suite 203 = 123 Easy St. Suite 203
Any help is appreciated.
I want to take 123 EASY sT. suite 203 = 123 Easy St. Suite 203
Any help is appreciated.
Hi,
That's a good solution, thanks for your help. I will mention that i'm getting tired of using the excel connector for all my workarounds. I've coded a number of workbooks to periodically update fields that can't be updated in Salesforce - hopefully some greater "in-built" functionality will be available in the future.
Message Edited by Jakester on 09-16-2008 09:26 AM
DemandTools' Mass Impact module has a built-in Proper() function that I never used, but tested it out today and it is way better than Excel's. This is still a data cleansing function after-the-fact, rather than when the record is created, but I was super-impressed with the results. It catches things such as McDonald and a whole lot of other things that I was adjusting manually in Excel. You can find out more about DemandTools on Appexchange.
Message Edited by rpr2 on 09-16-2008 09:26 AM
Just noticed where the previous administrator had this set up:
upper(left(OVSuburb__c,1)) & lower(trim(mid(OVSuburb__c,2,60)))