AnsweredAssumed Answered

NumToJText ( number ; 3 ;  0 ) gives incorrect result with 1 and 0

Question asked by raybaudi on Aug 2, 2013
Latest reply on Aug 8, 2013 by philmodjunk

Summary

NumToJText ( number ; 3 ;  0 ) gives incorrect result with 1 and 0

Product

FileMaker Pro

Version

11 and 12

Operating system version

windows

Description of the issue

I was searching a way to insert a character between each digit of a number, without a recursive custom function or a script.
The idea was to use the NumToJText ( ) function with 3 as separator parameter.
But it doesn't work correctly when there is one or more 1 and 0.
For example:
NumToJText ( 234 ; 3 ;  0 ) returns: 2百3十4
NumToJText ( 123456789 ; 3 ;  0 ) returns: 1億2千3百4十5万6千7百8十9
but:
NumToJText ( 134 ; 3 ;  0 ) returns: 百3十4
NumToJText ( 111 ; 3 ;  0 ) returns: 百十1
NumToJText ( 100 ; 3 ;  0 ) returns: 百
NumToJText ( 11111 ; 3 ;  0 ) returns: 1万千百十1

Is it a bug ?

Outcomes