Cubewise
SolutionsEducationSoftwareResourcesSupportCompany
Contact us
EN

    CapIt function for IBM Planning Analytics (TM1)

      CAPIT capitalises the first letter of every word in a string. CAPIT can be useful to standardise the appearance of object names when the data is not presented uniformly. Utilising this function with inconsistent formatting would help clean up the presentation, making it easier for users to digest.

      Where can the CapIt function be used?


      Rules and TurboIntegrator

        Which TM1 Server version is the CapIt function available for?

        Version 11 and 12

          What is the syntax for CapIt?

          CapIt(string)​

          • String = A text string

          Relevant Functions

          • CapIt = capitalises the first letter of every word in a string
          • Char = Converts the ASCII numeric code into the character
          • Code = Converts the character to the ASCII numeric code
          • CodeW = Returns the UTF-8 numeric code for a specified character within a string
          • Delet = Deletes a specified number of characters from a specified position within a string
          • Fill = Repeats a string to the specified number of lengths
          • Insrt = Inserts one string into another string at the given position number
          • Long = Returns the length of the string
          • Lower = converts text characters to lowercase
          • Numbr = Converts string character to a number
          • Scan = Searches the specified substring within a string and returns the starting position of the substring
          • Str = Converts number to a string character
          • SubSt = Returns the substring of a specified string
          • Trim = Removes any leading and trailing spaces from a string
          • Upper = Converts text characters to upper case