Format numerical values in Jira Automation

Question

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 Answer

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:

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.