-
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
Best Practices To Be Followed In Salesforce Lightning Web Components
Introduction Lightning Web Components (LWC) is a modern Salesforce development method that uses open web standards (such as standard JavaScript and HTML), allowing developers who…
Salesforce Marketing Cloud Connect: Subscriber Key Migration
If you’ve decided to implement Marketing Cloud Connect in your organization, one of the first considerations will be how to handle Subscriber Keys from Sales or Service…
How To Integrate Salesforce With Netsuite?
Salesforce is the worldwide leader in making revolutionary business applications, served from the cloud and are designed to help generate leads for an organization. Also,…
Popular Salesforce Videos
Nested Lists in Apex | Salesforce Development Tutorial for Beginners
In this video, Shrey has explained in detail the process to create a Nested List in Apex. Watch the full video to understand. If you…
Salesforce Development and Career Opportunities
Salesforce is the world’s #1 customer relationship management (CRM) platform. Salesforce allows sales reps to see everything about a customer in one place and provide…
ChargeOn Payment Processing For Salesforce: Enhance Your Salesforce Payments
Do you wish to receive payments in Salesforce but are unsure how to get started? Don’t worry; we've got you covered. ChargeOn is a fully…
