Number formatting in pipelines.

This is Straight cut and paste from chatGPT , maybe useful to you , since I have never across this number format (I am from India)

--- 

Yes, in Quickbase with Jinja templating, you can manipulate the format of numbers to suit your needs.

Given the number format you've mentioned (123.456,78), it seems you're using a European-style number format where the period is used as the thousands separator and the comma is used as the decimal separator.

If you want to convert this format (123.456,78) to a more standard format (123456.78), you can use Jinja's string manipulation capabilities.

Here's a step-by-step breakdown:

1. Replace the period (.) with nothing, effectively removing it.
2. Replace the comma (,) with a period (.).

Here's how you can achieve this using Jinja:

{% set number_str = '123.456,78' %}
{% set standard_format = number_str.replace('.', '').replace(',', '.') %}
{{ standard_format }}

This will give you `123456.78`.

Now, if you have this number in a field in Quickbase, you'll have to reference that field in your Jinja template, and then apply the above transformations.

Remember, this approach assumes that your number is always formatted with a period as the thousands separator and a comma as the decimal separator

------------------------------
Prashant Maheshwari
------------------------------