-
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
Some Common Differences in Salesforce
Let's have a look on some specific common differences that are mostly used on day to day work in Salesforce. 1. Data Loader Vs Data…
Standard and Custom Percentage Calculator in Salesforce Lightning Component
Requirement We are going to calculate some standard percentage and custom percentage i.e. any percent you want to calculate any input number. On click of…
Dawn of the Era of Salesforce Lightning
Whenever the name of Salesforce comes up, the reactions that people give are- “Best Cloud Computing Services”, “Best cloud-based CRM”, “Amazing CRM services”, “Revolutionary CRM”…
Popular Salesforce Videos
How to Set Up Salesforce Customer Community
Step by Step Salesforce tutorial for quickly setting up a Customer Community with Customer Service (Napili) Template.
Case Study: Connecting Ferries with Salesforce IoT Explorer
The data that Salesforce IoT Explorer brings to the table helps businesses take real-time business decisions that translates into better customer service. Salesforce, in its…
Salesforce Tutorial - How to Create Custom App in Salesforce
Apps, Tabs, Objects are basic Building Blocks of Salesforce. In this video, I am explaining how exactly you will able to develop a custom app…
