2 Replies Latest reply on May 6, 2012 8:48 PM by DavidMenlow

    Counting letters in a text field

    DavidMenlow

      Title

      Counting letters in a text field

      Post

      I have a calculation field that concatenates other fields, and with the results I do a simple copy and paste into a text message.  I know about the WordCount function, but I need to get a calculated result of all the characters in this field, including spaces and special characters.  Any ideas how to do this?

        • 1. Re: NoFields
          johnhorner

          if i understand correctly, i think all you need to do is use the "length ( )" function... or are you trying to subtotal the different categories (e.g. spaces, letters, numbers, etc)?  to do that i think you would nest the "filter ( )" function inside the length function and specify the criteria needed for each type.  hope that helps...

          • 2. Re: NoFields
            DavidMenlow

            Thank you John.  I've used the Lenth() function in a much more complicated manner previously and just didn't think of it this way.