dollar figure to words function

[Mike Reed]

Hi,
Can anyone tell what the Alpha function is to covert a dollar figure to words. I can't find it in the documentation. For example:
"$2500.78" to "Two thousand five hundred and 78/100 dollars"

Thanks,

Mike

[Steve Workings]

Re: dollar figure to words function

Format_Data() may have what you need Mike. Note I'm including the length parameter here:

format_data(2500.78,"XF$", 100)

[Mike Reed]

Re: dollar figure to words function

Thank you Steve. Couldn't find it and couldn't remember it. Getting old does that sometimes I guess.
Mike

[Jay Talbott]

Re: dollar figure to words function

If this helps:

The {dialog.object}.setValue line in red below places the words in a specific text box on the form. You might need to change this, but it is quite easy to do.
Also if you want to use the term "cents" instead of a fraction for the decimal portion, that code is in here too, it is remarked out.
This JS function also removes dollar signs and commas, because they wreak havoc when trying to determine the numerical value of something.


function GetNumber2d(checkAmount) {
checkAmount = checkAmount.replace(/,/g, "");
checkAmount = checkAmount.replace(/\$/g, "");
var gf = ""
var gg = ""
var gh = ""
var gi = ""
var gj = ""
var gc = "zero"
var dd = ""
var cc = ""

var sNumber = Math.floor(checkAmount);
var sNumbec = Math.floor((checkAmount % 1).toFixed(2) * 100);

var sNum2 = String(sNumber);
var sNumc = String(sNumbec);

if (sNumber == 1){dd = " Dollar "}
else {dd = " Dollars "}
// if (sNumbec == 1){cc = " cent"}
// else {cc = " cents"}

// if (sNumbec < 1){gc = "zero"}
// if (sNumc=="") {gc = "zero"}
if (sNumc > 0) {gc = hto(sNumc)}

var j = sNum2.length
var hNum2 = sNum2.substring((j-3),((j-3)+3))

if (hNum2 > 0) {
gf = hto(hNum2) + ""
}

var tNum2 = sNum2.substring((j-6),(j-6)+3)
if (tNum2 > 0) {
gg = hto(tNum2) + " thousand "
}

var mNum2 = sNum2.substring((j-9),(j-9)+3)
if (mNum2 > 0) {
gh = hto(mNum2) + " million "
}

var bNum2 = sNum2.substring((j-12),(j-12)+3)
if (bNum2 > 0) {
gi = hto(bNum2) + " billion "
}

var trNum2 = sNum2.substring((j-15),(j-15)+3)
if (trNum2 > 0) {
gj = hto(trNum2) + " trillion "
}

if (sNumber < 1){
gf = "zero"
}


var dds = toTitleCase(gj) + toTitleCase(gi) + toTitleCase(gh) + toTitleCase(gg) + toTitleCase(gf);
if (dds == ""){dds = "zero"}

myResult= " " + dds + dd + " and " + sNumbec +'/100';
{dialog.object}.setValue('NumbersWrittenOut',myResult);}




function toTitleCase(str)
{
return str.replace(/\w\S*/g, function(txt){return txt.charAt(0).toUpperCase() + txt.substr(1).toLowerCase();});
}

function hto(ff){
var sNum3 = ""
var p1=""
var p2=""
var p3=""

var hy=""
var n1 = new Array
('', 'one', 'two', 'three', 'four', 'five', 'six',
'seven', 'eight', 'nine', 'ten', 'eleven', 'twelve',
'thirteen', 'fourteen', 'fifteen', 'sixteen', 'seventeen',
'eighteen', 'nineteen')

var n2 = new Array('', '', 'twenty', 'thirty', 'forty',
'fifty', 'sixty', 'seventy', 'eighty', 'ninety')


sNum3 = ff
var j = sNum3.length
var h3 = sNum3.substring((j-3),(j-3)+1)
if (h3 > 0) {
p3= n1[h3] + " hundred "}
else {p3=""}

var t2 = parseInt(sNum3.substring((j-2),(j-2)+1), 10)
var u1 = parseInt(sNum3.substring((j-1),(j-1)+1), 10)
var tu21 = parseInt(sNum3.substring((j-2),(j-2)+2), 10)

if (tu21 == 0) {
p1="";
p2="";
}

else if ((t2 < 1) && (u1 > 0)) {
p2="";
p1= n1[u1]
}

else if (tu21 < 20) {
p2="";
p1= n1[tu21]
}

else if ((t2 > 1) && (u1 == 0)) {
p2= n2[t2]
p1=""
}

else {
p2= n2[t2] + "-"
p1=n1[u1]
}

ff = p3 + p2 + p1

return ff;
}

function ohto(ff){
var sNum3 = ""
var p1=""
var p2=""
var p3=""

var hy=""
var n1 = new Array
('', 'first', 'second', 'third', 'fourth', 'fifth', 'sixth',
'seventh', 'eighth', 'ninth', 'tenth', 'eleventh', 'twelfth',
'thirteenth', 'fourteenth', 'fifteenth', 'sixteenth', 'seventeenth',
'eighteenth', 'nineteenth')

var n2 = new Array('', '', 'twentieth', 'thirtieth', 'fortieth',
'fiftieth', 'sixtieth', 'seventieth', 'eightieth', 'ninetieth')

var n3 = new Array('', '', 'twenty', 'thirty', 'forty',
'fifty', 'sixty', 'seventy', 'eighty', 'ninety')

var n4 = new Array
('', 'one', 'two', 'three', 'four', 'five', 'six',
'seven', 'eight', 'nine', 'ten', 'eleven', 'twelve',
'thirteen', 'fourteen', 'fifteen', 'sixteen', 'seventeen',
'eighteen', 'nineteen')


sNum3 = ff
var j = sNum3.length
var h3 = sNum3.substring((j-3),(j-3)+1)
if (h3 > 0) {
p3= n4[h3] + " hundred "}
else {p3=""}

var t2 = parseInt(sNum3.substring((j-2),(j-2)+1), 10)
var u1 = parseInt(sNum3.substring((j-1),(j-1)+1), 10)
var tu21 = parseInt(sNum3.substring((j-2),(j-2)+2), 10)

if (tu21 == 0) {
p1="";
p2="";
p3= n4[h3] + " hundredth "
}

else if ((t2 < 1) && (u1 > 0)) {
p2="";
p1= n1[u1]
}

else if (tu21 < 20) {
p2="";
p1= n1[tu21]
}

else if ((t2 > 1) && (u1 == 0)) {
p2= n2[t2]
p1=""
}

else {
p2= n3[t2] + "-"
p1=n1[u1]
}

ff = p3 + p2 + p1

return ff;
}




function gesult(ff){

if (Number.prototype.toFixed) {
ff = ff.toFixed(2);
ff = parseFloat(ff);
}
else {
var leftSide = Math.floor(ff);
var rightSide = ff - leftSide;
ff = leftSide + Math.round(rightSide *1e+14)/1e+14;
}

return comma(ff);
}

function comma(num) {
var n = Math.floor(num);
var myNum = num + "";
var myDec = ""

if (myNum.indexOf('.',0) > -1){
myDec = myNum.substring(myNum.indexOf('.',0),myNum.length);
}

var arr=new Array('0'), i=0;
while (n>0)
{arr[i]=''+n%1000; n=Math.floor(n/1000); i++;}
arr=arr.reverse();
for (var i in arr) if (i>0)
while (arr[i].length<3) arr[i]='0'+arr[i];
return arr.join() + myDec;
}

[CharlesParker]

Re: dollar figure to words function

Jay - great contribution to the thread - thank you! Really like the videos on getting started with xbasic at http://alphatechnologysolutions.com btw as well!
Yes - I'm giving you a little shout out here!

[Jay Talbott]

Re: dollar figure to words function

Thanks for your kind words.
Jay