Filemaker Pro 8.5 Educational Maintenance T1 TJ086LL/A User Manual

Chapter 12

  

|

  Text functions     185

Converts from Hankaku alphanumeric and symbols to Zenkaku alphanumeric and 
symbols.

RomanZenkaku(“Macintosh”) returns 

SerialIncrement(text;incrementBy) 

text - any text that also contains a number
incrementBy - any numeric 

 to increment the text by

text

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.

SerialIncrement(“abc12”;1) returns 

.

SerialIncrement(“abc12”;7) returns 

.

SerialIncrement(“abc12”;-1) returns 

.

SerialIncrement(“abc12”;1.2) returns 

.

SerialIncrement(“abc1.2”;1.2) returns 

.

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 

.