5 Replies Latest reply on Aug 8, 2013 9:17 AM by philmodjunk

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

    raybaudi

      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 ?