SerialIncrement()

Category: Text

Syntax: SerialIncrement ( text; incrementBy )

Parameters:

textAny text or text expression that contains an alphanumeric string.

incrementByA number or numeric expression with which to increment the text value.

Data type returned: Text

Description:

Returns the combined text and number from the text value, where the numeric portion of the text has been incremented by the value specified in the incrementBy parameter.

The incrementBy value is truncated to an integer when incrementing. Positive and negative numbers are accepted.

Examples:

Function

Results

SerialIncrement ("test1"; 2)

Returns test3.

SerialIncrement ("project_plan_v12.3"; -1)

Returns project_plan_v12.2.

SerialIncrement ("2hithere3"; 3)

Returns 2hithere6.

Категории