Working with text strings in Formula language for Lotus Notes
Here you can learn about the Formula language for Lotus Notes functions that are used to manage text strings.
Working with text strings in Formula language
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); |
A Formula language for Lotus Notes introduction
Home: Introduction
Tip 1: What is Lotus Formula Language?
Tip 2: Working with variables in Formula language for Lotus Notes
Tip 3: Lotus Notes Formula language keywords
Tip 4: Working with operators in Formula language for Lotus Notes
Tip 5: Lotus Notes Formula language general syntax rules
Tip 6: What are Lotus Notes Formula language functions and commands?
Tip 7: Working with text strings in Formula language for Lotus Notes
![]() |
This chapter excerpt from Lotus Notes Developer's Toolbox, by Mark Elliott, is printed with permission from IBM Publishing, Copyright 2006. Click here for the chapter download or purchase the book here. |