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.

The following is tip #7 from "A Formula language for Lotus Notes introduction -- 7 tips in 7 minutes," excerpted from Chapter 5 of the book Lotus Notes Developer's Toolbox , published by IBM Publishing.

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

An Introduction to Formula Language 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.

This was first published in March 2007

Dig deeper on Lotus Notes 5

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchWindowsServer

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchEnterpriseLinux

SearchDataCenter

SearchExchange

SearchContentManagement

Close