nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Change the format number in script field

Camille Lecerf

Hi,

Could someone help me please? I would like to change the separators of my script field (number)

12,345.67 --> 12 345,67

How could I do this please? I think I have to write something here (in the Custom Script Field editor), but I don't know what: 2019-01-30 14_08_49-Script Fields.png

Accepted answers

Nic Brough -Adaptavist-

You'll need to do the formatting in your code, then just put $value into the template (or change the template to text)

All comments

Nic Brough -Adaptavist-

You'll need to do the formatting in your code, then just put $value into the template (or change the template to text)

Camille Lecerf

Hi Nic,

Thank you for your answer. Yet I don't know how to format it in the script... (I don't code)

Could you please tell me what to add in ?

Regards,

Camille

Nic Brough -Adaptavist-

The format you've put in the question is not familiar to me, I'm used to seeing people ask for numbers to come out in their local language format (e.g. in English and US English, we have the format you are converting from, but in Spanish, you'd see 12.345,67)

If it is a valid format for a country (probably is), then

return NumberFormat(getNumberInstance(Locale.xx).format($number))

Would format it for the country named by the xx (US for USA, CH for Switzerland, GB for the UK, DE for Germany etc)

Camille Lecerf

Thank you for your help. I added this at the top of my code

import java.text.NumberFormat

And that at the end:

def frenchnumber = NumberFormat.getCurrencyInstance(Locale.FRENCH).format($number);

return frenchnumber;

Yet, for 12,345.67 : I get 12 (what I expected was 12 354,67)

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

scriptrunner

custom-field

jira

adaptavist

jira-server

template

script

scripted-field