4 Replies Latest reply on Jul 12, 2018 3:35 PM by Stephen Hicks

    Numeric String Field Verification

    Vincent Baumel

      I've got a dimension whose domain consists of 11-character strings. I need to create a calculation that verifies each character as an integer. Ideally it would be like a KPI sum, saying:

       

      Entries:                            401,883

      Entries w/11 characters:  401,883

      Entries w/only integers:   401,883

       

       

      The LEN() function will get me the 11 character verification, but I don't have any idea how I can parse each individual character to test for integer vs non-integer.  Any ideas?