@LowerCase (Formula Language)

Converts the uppercase letters in the specified string to lowercase.

Syntax

@LowerCase( string )

Parameters

string

Text or text list. The string you want to convert to lowercase.

Return value

lowerCaseString

Text or text list. The string, converted to lowercase letters.

Usage

If the parameter is a list, the function operates on each element of the list, and the return value is a list with the same number of elements.

This function is useful when you want to search for a particular value and cannot predict whether it appears in lowercase or uppercase letters, or a combination of the two. You can also use it as an input translation formula to convert the contents of a field to lowercase.

Examples

  1. This example returns juan mendoza.
    @LowerCase("Juan Mendoza")
  2. This example returns arm chair if the Furniture field contains "Arm Chair," "Arm chair," "arm chair," or "ARM CHAIR," or any other variation.
    @LowerCase(Furniture)
  3. This example returns fletcher if William Fletcher is the name associated with the current hierarchical User ID.
    @LowerCase(@Right(@Name([CN];@UserName); " "))
  4. This example returns juan and mendoza in a list.
    @LowerCase("Juan" : "Mendoza")