I am pulling values from fields formatted for number -> currency but the values that populate the variables are straight numbers. e.g. the field contains 12345 and when it loses focus, it automatically converts it to 1,2345.00.
I need the variable to also convert the number to the latter format.
function formatCurrency(num) {num = num.toString().replace(/\$|\,/g,'');if(isNaN(num))num = "0";sign = (num == (num = Math.abs(num)));num = Math.floor(num*100+0.50000000001);cents = num%100;num = Math.floor(num/100).toString();if(cents<10)cents = "0" + cents;for (var i = 0; i < Math.floor((num.length-(1+i))/3); i++)num = num.substring(0,num.length-(4*i+3))+','+num.substring(num.length-(4*i+3));return (((sign)?'':'-') + '$' + num + '.' + cents);}
// Get the DME and convert for currencyvar cDME = formatCurrency(this.getField("DME Max").value);
var cCont = util.printf("$%.2f", this.getField("Billing Rate").value);// assign values to the parts of the format stringvar cCurrency = '$'; // currency symbolvar nDecSep = ',0'; // use ',' thousand separator and '.' decimal pointvar nFlags = ''; // no sign or leading spacevar nWidth = ''; // no maditory widthvar nPrecision = .2; // number of decimal placesvar cConvChar = 'f'; // floating number// build format stringvar cFormat = cCurrency + '%' + nDecSep + nFlags + nWidth + nPrecision + cConvChar;var cCont = util.printf(cFormat, this.getField("Billing Rate").value); // or the foramt string as a string within the method:var cCont = util.printf('$%,0.2f', this.getField("Billing Rate").value);
If the field has formatting applied to it, the values you apply in a script will have that formatting.
- AcrobatUsers Community Expert - Contact me personally at try6767 [at] gmail [dot] com
Check out my custom-made scripts website: http://try67.blogspot.com