-
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
All You Need to Know About the Salesforce Service Cloud
Elevating Customer Support: Unveiling the Power of Salesforce Service Cloud In today's fast-paced and interconnected world, providing exceptional customer service has become a cornerstone of…
Native Accounting in Salesforce vs Accounting Software Integrations
Salesforce CRM was not designed as a standalone accounting software solution. But everything your organization does in Salesforce touches accounting on some level. In order…
Top Salesforce Consulting Companies for CRM Excellence
Salesforce not only stands tall in the CRM world but is also the go-to for innovation and efficiency. It's not just a platform; it's a…
Popular Salesforce Videos
Automate Your App With and Without Code | Salesforce Developer Tutorial
In this video, you will learn how you can automate your business process with and without code. This video teaches you how to use a…
AMPscript FOR LOOP - Salesforce Marketing Cloud Functions in 5 minutes
Salesforce Marketing Cloud functions in 5 minutes! In this video Cameron Robert shows how FOR LOOPs work in Salesforce Marketing Cloud using some helpful visuals…
Salesforce Lightning Training
Here, the video is about the Salesforce Lightning Tutorial. These video covers comprise real-world projects that will introduce you to advanced concepts such as Lightning…
