1 Reply Latest reply on Apr 2, 2014 10:37 AM by philmodjunk

    counting the amount of numbers in a field

    ryanrivkin

      Title

      counting the amount of numbers in a field

      Post

           Hey everyone, 

            

           so what i want to do is validate that there are at least 4 numbers in a field, what i don't have is the way to count the digits in the field and not add them together. 

           i tried    count (field)

           and i tried    length (field)
            

           maby i implemented them wrong

        • 1. Re: counting the amount of numbers in a field
          philmodjunk

               What does the data look like in this field?

               If you have

               23

               in a field named "Value", then Length ( Value ) will return 2, that there are two characters in the field.

               So with

               6721

               in the field, length will return 4.

               But if you also have spaces or other characters in the same field, you can see 4 visible characters but length will count both the visible and invisible characters in the field.

               You might need to use:

               Length ( Filter ( Value ; 9876543210 ) )

               to get a count of just the numeric characters in the field.