Filemaker TH325Z/A Ficha Técnica descarregar pdf (Página 164)

164 FileMaker Functions Reference

Filter

Format

Filter(textToFilter;filterText)

Parameters

textToFilter - any text expression or text field

filterText - the characters to preserve in the specified text

Data type returned

text

Description

Returns from textToFilter only those characters specified in filterText, in the

order that they were originally entered in textToFilter. If filterText doesn’t have

any characters, an empty string is returned. The Filter function is case-sensitive.

Examples

Filter(“(408)555-1212”;“0123456789”) returns 4085551212.

Filter(“AaBb”;“AB”) returns AB.

The following example removes all text from the provided data, then formats the

remaining numbers in the preferred phone number formatting:

Let(phone = filter(theField;“0123456789”);“(“ & left(phone;3) &

“)” & middle(phone;4;3) & “-” & middle(phone;7;4))

If theField contains Work: 408.555.1212 this calculation returns (408)555-1212.

FilterValues

Format

FilterValues(textToFilter; filterValues)

Parameters

textToFilter - any text expression or text field

filterValues - values that you want to preserve in the specified text

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

Data type returned

text

1 2 ... 159 160 161 162 163 164 165 166 167 168 169 ... 237 238

Sem comentários

Filemaker TH325Z/A Ficha Técnica Página 164