Lotus Domino Designer 8 Help

FORMULA LANGUAGE

@Char
Example

Converts an IBM Code Page 850 code number into the corresponding single character string.

Syntax

@Char( codeNumber )

Parameters

codeNumber

Number. Any number between 0 and 255. Noninteger numbers are truncated to integers.

Return value

correspondingChar

Text. A single character that corresponds to

codeNumber.

Usage

@Char(10) returns a carriage return.

@Char(9) returns a tab.

Note In the Notes client, the codeNumber parameters 0 and 9 do not work in column formulas.

@Char(13) returns a carriage return when used in an @Prompt formula.

To add multiple lines to a single column row:

1. In the View Properties box:

Change the Lines per row to the number of carriage returns you want to include in the row.
Select Shrink rows to content.

2. In the Column Properties box:

Choose New Line as the Multi-value separator.
Deselect the Show multiple values as separate entries checkbox.

3. In the code for the column formula, specify each string or number that you want to display on a new line as a separate value. Since you set the Multi-value separator to New Line, this inserts a carriage return between each value. For example, the following column formula vertically lists the content of the FirstName field above the content of the LastName field in the column row:

first:= FirstName; last := LastName; @Trim(first : last)

Language cross-reference

Tab function of LotusScript language

AddNewLine method of NotesRichTextItem class

addNewLine method of Java RichTextParagraphStyle class

Example
See Also

Trimming, repeating, adding a new line, and changing case

Converting data types

"Create your own formula debugger" on Tips from the Lotus Developer Domain

Glossary

Feedback on Help or Product Usability?

Help on Help

All Help Contents

Glossary