Category: Text

Syntax: SerialIncrement ( text; incrementBy )


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


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.




SerialIncrement ("test1"; 2)

Returns test3.

SerialIncrement ("project_plan_v12.3"; -1)

Returns project_plan_v12.2.

SerialIncrement ("2hithere3"; 3)

Returns 2hithere6.

FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352
Simiral book on Amazon © 2008-2017.
If you may any questions please contact us: