This idea has been delivered and can no longer be voted or commented on. If you’d like to add to this conversation, please post a new idea.
320  Points voting closed
Delivered in Winter '08
Idea is generally available.

When creating formula fields in custom objects, in the advanced formula tab would be useful to have a formula to convert text to upper case, similar to the UCase() function of Basic, the string.toUpperCase() of Java, or the string.ToUpper() of C#.
With this function the following formula could be avoided:

IF( OR({!Unit_of_Measure__c}="SQM",{!Unit_of_Measure__c}="Sqm",{!Unit_of_Measure__c}="sqm") , value_if_true, value_if_false)

and i.e. could be replaced with some more efficient code like:

IF( UCase({!Unit_of_Measure__c})="SQM", value_if_true, value_if_false)

A lower case version of the function would also be nice.

· Flag

Latest Comment from Salesforce

  • Mary Scotton - 9 years ago

    Two new formula functions are coming in Winter '08: UPPER() Converts all letters in the specified string to uppercase. If there are characters in the string that are not letters, they are unaffected by this function. For example, UPPER('salesforce.com') returns 'SALESFORCE.COM' LOWER() Converts all letters in the specified string to lowercase. If there are characters in the string that are not letters, they are unaffected by this function. For example, LOWER(' SALESFORCE.COM') returns ' salesforce.com'
  • Upvotes
  • Downvotes

Ideas

Apps

from AppExchange

Questions

Help us to keep IdeaExchange clean by pointing out overlapping ideas. We'll investigate your suggestion and merge the ideas if it makes sense.



 

 

Thanks for your merge suggestion. We will review it shortly and merge the ideas if applicable.

Salesforce takes abuse situations very seriously. Examples of abuse include but are not limited to posting of offensive language or fraudulent statements. To help us process your request as quickly as possible, please fill out the form below describing the situation. For privacy and security reasons, the final outcome of an abuse case may not be revealed to the person who reported it.


 

Thank you for your feedback. We take abuse seriously and will investigate this issue and take appropriate action.