FORMULA LANGUAGE


@Text
Example

Converts any value to a text string.

Syntax

@Text( value ; format­string )

Parameters

value


Note Conversion of rich text is new with Release 6.

format-string


Return value

textValue


@Text with time­date components

There are four separate categories of time­date, format­string components. You can include up to four components, but only one from each category.

SymbolMeaning
D0Year, month, and day
D1Month and day, year if it is not the current year
D2Month and day
D3Month and year
T0Hour, minute, and second
T1Hour and minute
Z0Always convert time to this zone
Z1Display zone only when it is not this zone
Z2Display zone always
S0Date only
S1Time only
S2Date and time
S3Date, time, Today, or Yesterday
Sx Use when you cannot predict the exact format of the value being passed, but you know that it is either a time, a date, or both.

@Text with number values

For number values, compose a format­string by combining any of the following components into a string.

SymbolMeaning
GGeneral format (significant digits only)
FFixed format (set number of decimal places)
SScientific format (E notation)
CCurrency format (two decimal places)
,Punctuated at thousands (using U.S. format)
%Percentage format
()Parentheses around negative numbers
numberNumber of digits of precision

Usage

Once a number value is converted to text, you will not be able to use the number for arithmetic calculations.

Rich text conversion loses attachments and all formatting except tabs and spaces.

Rich text conversion does not work in column formulas unless the column allows non-summary data.

When rich text is converted in a document, the document must be saved before the conversion becomes visible.

You can use @Abstract to convert rich text fields to plain text in summary format as shown below:


Language cross-reference

CStr function of LotusScript language

GetFormattedText method in LotusScript NotesRichTextItem class

getFormattedText method in Java RichTextItem class

Example
See Also