Free cookie consent management tool by TermsFeed

mid() Function

Function

mid( text, start_num, num_chars )

Returns a substring from the middle of the specified text.

Parameters

Keyword Type Description

text

Text

The text from which the substring will be extracted.

start_num

Number

The positional index of the first character of the substring to be returned.

num_chars

Number

The length in characters of the substring to extract.

Returns

Text

Usage considerations

The first character of the entire text value is considered to have an index = 1.

Examples

mid("boston",4,2) returns to

Feature compatibility

The table below lists this function's compatibility with various features in Appian.
Feature Compatibility Note
Portals Compatible
Offline Mobile Compatible
Sync-Time Custom Record Fields Compatible

Can be used to create a custom record field that only evaluates at sync time.

Real-Time Custom Record Fields Incompatible

Custom record fields that evaluate in real time must be configured using one or more Custom Field functions.

Process Reports Compatible
Process Events Compatible

Feedback