Many formulas are used to manage and manipulate text strings. Using functions, you can parse information, implement data validation, and enforce consistency across data values. For example, the following are some of the more commonly used functions used to manage text strings.
| Function
|
Description
|
Example
|
| @UpperCase
|
Converts a string to uppercase. Syntax:
@UpperCase ( String );
string -- Any text string.
|
@Uppercase
( "january" );
Result: "JANUARY"
|
| @LowerCase
|
Converts a string to lowercase. Syntax:
@LowerCase ( String );
string -- Any text string.
|
@lowercase
( "JANUARY" );
Result: "january"
|
| @ProperCase
|
Converts the first letter of each word to capital. Syntax:
@ProperCase ( String );
string -- Any text string.
|
@Propercase
( "john doe" );
Result: "John Doe"
|
| @Trim
|
Removes leading and trailing spaces from a text string and removes duplicate spaces between text words. Syntax:
@Trim ( String );
string -- Any text string.
|
@Trim
( " today is Monday " );
Result: "today is Monday"
|
| @Text
|
Converts a number, date, or time to a text string. Syntax:
@Text ( value );
value -- The value to be converted into a string.
|
@Text ( 100 );
Result: "100"
@Text ( @Today );
Result: "01/01/2005"
|
| @LeftBack
|
Searches a string from left to right and returns a substring.
|
This example returns "Mark".
@LeftBack ( "Mark Elliott";" ");
This example returns "Mark Ellio".
@LeftBack ("Mark Elliott"; 2);
|
| @RightBack
|
Searches a string from right to left and returns a substring.
|
This example returns "Elliott".
@RightBack ( "Mark Elliott";" ");
This example returns "rk Elliott".
@RightBack ("Mark Elliott"; 2);
|
Home: 
