Number format [# ##0,00] in number field

Forum|Forum|6 years ago
January 29, 2020
3 replies
5609 views

Hi,

Unfortunately in PDF there is no option to set format in number field like this in Excel '# ##0,00'

example: 1 456 123,45 or 1 456,62.

Somebody knows the script which format number like in example above ???

PLEASE HELP !!!!

Wieslaw

This topic has been closed for replies.

Correct answer Thom Parker

Ok, so that's simple, to convert it into a number for an Acrobat calculation, just replace the "," with a "."

event.value = util.printf("%,2.2f",event.value.replace("\,",".")).toString().replace(/\./gim," ");

Here's a double RegExp that will perform the same formatting;

event.value = event.value.replace(/(\d+)(p=\,)?/,function(a){return a.split("").reverse().join("").replace(/(\d{3})/g,"$1 ").split("").reverse().join("");})

JR Boulay

Community Expert

Et pour ne pas afficher un zéro tout seul il faut lui ajouter une autre ligne, toujours en script de "format personnalisé" :

event.value = util.printf("%,2.2f",event.value).toString().replace(/\./gim," ");

if (event.value == 0) {event.value = ""};

Acrobate du PDF, InDesigner et Photoshopographe

R

robertb87361850Author

Known Participant

Thank you very much for your answer, but unfortunately it doesn't work

Please look: https://www.iform.pl/txtfile/example.pdf

I still have ''0,00", these fields should be empty, other thing is I need to use comma instead of dot. If I use comma, I have a result: 1,#R

JR Boulay

Community Expert

Le plus simple pour afficher le format Français (espace entre les milliers et virgule avant les décimales) avec 2 décimales c'est d'utiliser ce script de "format personnalisé" :

event.value = util.printf("%,2.2f",event.value).toString().replace(/\./gim," ");

Acrobate du PDF, InDesigner et Photoshopographe