2 Replies Latest reply on Jul 25, 2014 3:21 PM by nihmbrisby

    NumToJText

    nihmbrisby
    nihmbrisby Jul 25, 2014 11:40 AM

      Title

      NumToJText

      Post

           So in browsing custom functions to format numbers and/or currency, I was a bit stunned to stumble upon that fact the filemaker has a native function to insert commas where I'd have least expected it- NumToJtext.  The functions description is converts roman numbers in number to japanese text.  The format is: NumToJText(number;separator;characterType).  

           The functions I see this using NumToJText select '0' for type which corresponds to "half width (Hankaku) number".  I googled this, but I'm still unsure- Will using this function just to insert commas (ie 30000000 to 3,000,000) have any unintended side effects?

      • 67 Views
      • Tags:
        • 1. Re: NumToJText
          philmodjunk
          philmodjunk Jul 25, 2014 3:16 PM (in response to nihmbrisby)

               I learned this same trick from a post here by Raybaudi. As far as I can tell, there should be no trouble using this as a calculation to insert the comma as a thousands separator. But in many situations, such a calculation is unnecessary as you can use data formatting (even on merge text--both fields and variables) to add the same formatting.

          • 2. Re: NumToJText
            nihmbrisby
            nihmbrisby Jul 25, 2014 3:21 PM (in response to nihmbrisby)

                 Thanks phil.  I need to display a calc with percentages, currencies, and text so NumtoJtext based calcs fit the bill.  Good to hear its safe, thanks.