Format numerical values in Jira Automation

[Claas Babendererde]

Unfortunately, I cannot sort values because of commas and dots. In the description, I only find the exact opposite of what I am looking for:

"Format numerical values

format

Formats a number in US locale. For example, 123412345 becomes 123,412,345.

1 {{issue.Invoice Amount.format}}"

In my field, I receive values as follows:
12.124,22
4,22
69.45,23

I want them as follows
12124,22
4,22
6945,23

How can I make sure other than the decimal separator I get rid of all the delimiters?

[Mark Segall · Accepted solution]

Hi @Claas Babendererde 

Is the intent to simply take a number and save it to a field without the commas?  If so, you could do this:

{{issue.Invoice Amount.remove(",")}}

However, if the data is being saved to a numeric field and the desire is to have that numeric field display without the thousand separator, you've hit a limitation:

https://jira.atlassian.com/browse/JRACLOUD-45545

The most common workaround I've seen for this situation is to use automation to copy the number to a text field and present that field on VIEW screens and Dashboards while using the number field for backend filters that require sorting by that number. 

[Claas Babendererde]

Much appreciated :)