Functions Reference

Chapter 12
|
Text functions 185
Description
Converts from Hankaku alphanumeric and symbols to Zenkaku alphanumeric and
symbols.
Examples
RomanZenkaku(“Macintosh”) returns M a c i n t o s h
SerialIncrement
Format
SerialIncrement(text;incrementBy)
Parameters
text - any text that also contains a number
incrementBy - any numeric expression to increment the text by
Data type returned
text
Description
Returns the combined text and numbers specified by text, with the numbers in text
incremented by the specified amount.
The text in text isn’t removed, as normally happens when performing standard math
against a value that contains text.
If the incrementBy value is a decimal number, then only the integer portion of
incrementBy value is added to the last number in text. Any character other than a
number is considered a separator. You can use both positive and negative incrementBy
values.
Examples
SerialIncrement(“abc12”;1) returns abc13.
SerialIncrement(“abc12”;7) returns abc19.
SerialIncrement(“abc12”;-1) returns abc11.
SerialIncrement(“abc12”;1.2) returns abc13.
SerialIncrement(“abc1.2”;1.2) returns abc1.3.
In the example below any character other than a number is considered as a separator and
the number on the far right is incremented.
SerialIncrement(“abc123;999”;1) returns abc123;1000.