-
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
Triggers in Salesforce - Learn All You Need to Know
What is Apex Trigger? Apex Triggers are used to refer to triggers in Salesforce. These are different and are accessible for particular tasks such as…
Salesforce Trailhead and Certification Leader Board - ForceLeaderBoard (Unofficial)
Force Leader Board - Salesforce Trailhead and Certification Leader Board Here it comes ... It's time to show your trailhead badges and certifications in on place.…
Trailhead: Your Best Ally to Learn Salesforce
Salesforce is one of the most used platforms in the business ecosystem. That is why the skills required for its successful operation are growing rapidly.…
Popular Salesforce Videos
Why Salesforce India is Primed for Growth
Amarendra Kumar, RVP of Alliances and Channels for India at Salesforce, says the region is poised for tremendous growth and opportunity over the next few…
How to create an App in Lighting Experience?
Salesforce is the trusted cloud when it comes to privacy and we are sure the Lightning will strike here thrice. As Salesforce is expanding, new…
How to Become a Salesforce Consultant at Any Age
Companies are in great demand of skilled Salesforce consultants as a means to achieve their Salesforce objectives for better output in their business. With the…