Filemaker TH325Z/A Fiche technique télécharger pdf (Page 183)

Chapter 12

Text functions 183

Parameters

text - any text expression or text field

numberOfValues - any numeric expression or field containing a number

Important See chapter 4, “Design functions” for information about literal text parameters.

Data type returned

text

Description

Returns a text result containing the specified numberOfValues in text starting from the

right.

Values are text items separated by carriage returns. You can place several items together

to create a carriage return-delimited list of values. A value can be empty, a single

character, a word, a sentence, or a paragraph. When you press Return you start creating

a new value. The last value will be recognized with or without a carriage return.

When the text parameter is a literal string as in the example below, you must insert a

literal carriage return character between each item in the list. In the Specify Calculation

dialog box, click the ¶ button to insert a literal carriage return character.

Each value that is returned ends with a carriage return, allowing lists to be easily

concatenated.

Examples

RightValues(“Plaid¶Canvas¶Suitcase”;2) returns

Canvas

Suitcase

RightValues(names;1) returns

John

when the names field contains

Sophie

Bill

John

RightWords

Format

RightWords(text;numberOfWords)

Parameters

text - any text expression

or text field

1 2 ... 178 179 180 181 182 183 184 185 186 187 188 ... 237 238

Pas de commentaire

Filemaker TH325Z/A Fiche technique Page 183