Text Function Descriptions
The following table describes the text functions shown in the list that is shown when you click Text Functions in the Calculation Editor pane. For other supported text functions, see Supplemental Text Functions. For more information, see Text Function Guidelines.
|
Function
|
Function Description
|
||
|---|---|---|---|
|
Concatenate( … )
|
Joins several text strings into one text string. You can also use the + operator to concatenate text strings.
|
||
|
Upper( Text )
|
Converts all letters in a text string to uppercase.
|
||
|
Lower( Text )
|
Converts all letters in a text string to lowercase.
|
||
|
Left( Text, NumberOfCharacters )
|
Returns the specified number of characters from the start of a text string.
|
||
|
Right( Text, NumberOfCharacters )
|
Returns the specified number of characters from the end of a text string.
|
||
|
Mid( Text, StartingPosition, NumberOfCharacters )
|
Returns the characters from the middle of a text string, given a starting position and length. The start_num is the 1-based position of the character in the string.
|
||
|
Trim( Text )
|
Removes all spaces from the beginning and end of a text string.
|
||
|
Length( Text )
|
Returns the number of characters in a text string.
|
||
|
IfThenElse( Condition, TrueResult, FalseResult )
|
If Condition is true, returns TrueResult. If Condition is false, returns FalseResult.
|
||
|
ToNumber( Text )
|
Converts the parameter to a number for use in numeric calculations.
|
||
|
ToString( Text )
|
Converts the parameter to a string value for use in text functions.
|
||
|
ToDate( x )
|
Converts the parameter to a date value for use in date functions.
|
||
|
User( )
|
Returns the current user's name for the Enterprise Edition. Returns the name of the Windows user logged onto the machine for the Team Edition.
|
||
|
Group( )
|
Returns the current user's group for the Enterprise Edition. Returns a blank for the Team Edition.
|
