Skip to main content
Turan_Elkhan
Turan_Elkhan
Inspiring
December 28, 2023
Answered

Numbers in German Local format

  • December 28, 2023
  • 1 reply
  • 790 views

Hello community.

I'm trying to convert string to number with some text in a text field.

Example:

var stringValue = "1099.33";
var numberValue = parseFloat(stringValue);

var formattedValue = numberValue.toLocaleString('de-DE', {
	minimumFractionDigits: 2,
	maximumFractionDigits: 2,
});

var textValue = "Wir haben " + formattedValue + " EUR.";

 

In this example, I want to achieve this format Wir haben 1.099,00 EUR. (in this format ###.###,###)
It only works in number fields, but not in text fields. Can anyone help me? I appreciate your help and thank you in advance.

    This topic has been closed for replies.
    Correct answer Turan_Elkhan

    for me has this format worked.

    var stringNumber = this.getField("Number").value;
var formattedNumber = util.printf("%.2f", stringNumber).replace(/\./, ',').replace(/(\d)(?=(\d{3})+,)/g, '$1.');
this.getField("Text").value = "You have " + formattedNumber + " EUR ".;

     For example: Field value is 1299,67. The result was as excepted:

    You have 1.299,67 EUR.

    1 reply

    try67
    Community Expert
    try67Community Expert
    Community Expert
    December 28, 2023

    Use this:

     

    var formattedValue = util.printf("%,2.2f", numberValue);

    Turan_Elkhan
    Turan_ElkhanAuthorCorrect answer
    Inspiring
    January 1, 2024

    for me has this format worked.

    var stringNumber = this.getField("Number").value;
var formattedNumber = util.printf("%.2f", stringNumber).replace(/\./, ',').replace(/(\d)(?=(\d{3})+,)/g, '$1.');
this.getField("Text").value = "You have " + formattedNumber + " EUR ".;

     For example: Field value is 1299,67. The result was as excepted:

    You have 1.299,67 EUR.
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices