Tungsten Transformation Modules
      Back to home
      1. Knowledge Base and Help Center
      2. Tungsten Automation (Formerly Kofax)
      3. Tungsten Transformation Modules

      Validating numbers in KTM - periods turns into comma issue (Windows Region Settings)

      Issue:


      When validating populated number fields numbers that have a period for decimal points are being converted to commas upon hitting "enter". For example, 1234.56 -> Hit "Enter" -> 1234,56.


      The commas are invalid in some customer databases, therefore causing an "invalid Number" error.


      Resolve:


      Windows region settings were found to be the cause of the issue.


      In Windows 10    

      1. Click the Start button, and then click Control Panel.
      2. Click Change date, time, or number formats.
      3. The Region dialog box appears.
      4. On the Formats tab, select the format you want to change from the drop-down list. Now click the Additional Settings button.
      5. Change Decimal symbol to a period "."
      7. Click  Apply and you should see the example numbers on the top change from 123,456,789,00 to 123,456,789.00
      8. You will need to reprocess Email batches from the message connector monitor for the changes to apply to those batches that are having issues.