|
-
February 28th, 2003, 01:44 PM
#1
JS to change currency to text
The script below almost works : )
for $999,999,999.99 it gives
Nine hundred ninety-nine million nine hundred ninety-nine thousand nine hundred ninety-nine dollars and ninety-nine cents
but for $900,990,100.00 it gives
Nine hundred nine hundred ninety thousand one hundred dollars
I have been looking at this too long. Help!
<html>
<head>
<SCRIPT LANGUAGE="JavaScript">
<!-- Begin
function filterNum(str) {
re = /^\$|,/g;
// remove "$" and ","
return str.replace(re, "");
}
// End -->
</script><script language="JavaScript">
<!--
function makeArray0() {
for (i = 0; i<makeArray0.arguments.length; i++)
this[i] = makeArray0.arguments[i];
}
var numbers = new makeArray0('','one','two','three','four','five','six','seven','eight','nine','ten','eleven','twelve'
,'thirteen','fourteen','fifthteen','sixteen','seventeen','eighteen','nineteen');
var numbers10 = new makeArray0('','ten','twenty','thirty','fourty','fifty','sixty','seventy','eighty','ninety');
var numbers100 = new makeArray0('','one hundred','two hundred','three hundred','four hundred','five hundred','six hundred','seven hundred','eight hundred','nine hundred');
function chequeAmount(input) {
var dollars = Math.floor(input);
var cents = Math.round((input*100 - dollars*100));
var cmillions = (dollars - dollars % 100000000) / 100000000;
dollars -= cmillions * 100000000;
var millions = (dollars - dollars % 1000000) / 1000000;
dollars -= millions * 1000000;
var cthousands = (dollars - dollars % 100000) / 100000;
dollars -= cthousands * 100000;
var thousands = (dollars - dollars % 1000) / 1000;
dollars -= thousands * 1000;
var hundreds = (dollars - dollars % 100) / 100;
dollars -= hundreds * 100;
var output = '';
output += (cmillions > 0 ? fN(cmillions) + ' hundred ' : '') +
(millions > 0 ? fN(millions) + ' million ' : '') +
(cthousands > 0 ? fN(cthousands) + ' hundred ' : '') +
(thousands > 0 ? fN(thousands) + ' thousand ' : '') +
(hundreds > 0 ? fN(hundreds) + ' hundred ' : '') +
(dollars > 0 ? fN(dollars) + ' ' : '') +
((millions > 0 || cthousands > 0 || thousands > 0 || hundreds > 0 || dollars > 0) ? 'dollars ' : '') +
((Math.floor(input) > 0 && cents > 0) ? 'and ' : '') +
(cents > 0 ? fN(cents) + ' cents' : '');
return output.substring(0,1).toUpperCase() + output.substring(1);
}
function fN(i) {
if (i<20) return numbers[i];
var cs = (i - i % 10) / 100, tens = (i - i % 10) / 10, units = i - (i - i % 10);
return numbers10[tens] + ((cs > 0 && tens > 0 && units > 0) ? '-' : '') + numbers[units];
}
//--></script>
</head>
<body>
<form>
<input type="text" name="amount" size="20">
<input type="text" name="answer" size="70">
<input type="button" value="Strip $ & ," onClick="this.form.answer.value=filterNum(this.form.amount.value)">
<input type="button" value="Convert" onClick="this.form.answer.value=chequeAmount(this.form.answer.value)">
</form>
</body>
</html>
__________________
Dan
-
February 28th, 2003, 04:44 PM
#2
This is a common mistake and I made it the first time I wrote the same thing for T-SQL in SQL Server.
What it is is you are accounting for n or nn in the millions and thousands position to account for the word value but for the n hundreds position you are not.
This will fix you up thou.
Change
Code:
output += (cmillions > 0 ? fN(cmillions) + ' hundred ' : '') +
(millions > 0 ? fN(millions) + ' million ' : '') +
(cthousands > 0 ? fN(cthousands) + ' hundred ' : '') +
(thousands > 0 ? fN(thousands) + ' thousand ' : '') +
(hundreds > 0 ? fN(hundreds) + ' hundred ' : '') +
(dollars > 0 ? fN(dollars) + ' ' : '') +
((millions > 0 || cthousands > 0 || thousands > 0 || hundreds > 0 || dollars > 0) ? 'dollars ' : '') +
((Math.floor(input) > 0 && cents > 0) ? 'and ' : '') +
(cents > 0 ? fN(cents) + ' cents' : '');
to
Code:
output += (cmillions > 0 ? fN(cmillions) + ' hundred ' : '') +
(millions > 0 ? fN(millions) : '') +
((cmillions > 0 || millions > 0) ? ' million ' : '') +
(cthousands > 0 ? fN(cthousands) + ' hundred ' : '') +
(thousands > 0 ? fN(thousands) : '') +
((cthousands > 0 || thousands > 0) ? ' thousand ' : '') +
(hundreds > 0 ? fN(hundreds) + ' hundred ' : '') +
(dollars > 0 ? fN(dollars) + ' ' : '') +
((cmillions > 0 || millions > 0 || cthousands > 0 || thousands > 0 || hundreds > 0 || dollars > 0) ? 'dollars ' : '') +
((Math.floor(input) > 0 && cents > 0) ? 'and ' : '') +
(cents > 0 ? fN(cents) + ' cents' : '');
WHat was however kind of ironic is you took them into account for 'dollors' to be output. You did miss cmillion there thou so 900,000,000 would have output 'Nine Hundred' originally.
Hope this helps.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
