-
What is the formula to count the characters in a text field?
What is the formula to count the characters in a text field?
-
1 Reply
-
Hi Tanu,
LEN() - returns the number of characters in a text string.
But LEN will count spaces as well.
If you want just CHR counts, you will need to TRIM the string and then use LEN to return the number of CHR. If you do not want to count special ASCII CHR like ();: etc you will need to adjust some code for that as well.
Log In to reply.
Popular Salesforce Blogs
Salesforce Classic Vs Salesforce Lightning: Which One is More Suitable?
When someone talks about Customer Relationship Management Software, Salesforce is never left behind! Be it ease-of-use, app marketplace, or customizability; everything about Salesforce Platforms is…
Deleting Apex Classes / Apex Triggers From Production Using Workbench | Salesforce Tutorial
This is a rare scenario that we might face when not using any IDE or Source Control as part of the Salesforce Development. In order…
Power of Search in Salesforce
Power of Search Salesforce Search: We use the built-in search function of the Salesforce platform to search for any record or file. It gives us…
Popular Salesforce Videos
Basics of Salesforce Flow in 15 minutes
In this video, Jitendra Zaa gives a detailed overview of the basics of Salesforce Flow in just 15 minutes. He covers everything from how to…
Dreamforce To You 2020 - All Set To Happen
The world has changed, and so has Dreamforce. Instead of everyone coming to Dreamforce, Dreamforce is coming to you — to your kitchen, to your…
Salesforce Sales Cloud Basics
This short video shows how easy to create & manage leads and to convert it to opportunity, contacts & accounts using Salesforce Sales Cloud. Please…