View Single Post
  #1  
Old August 19th, 2008, 03:23 PM
Admin's Avatar
Admin Admin is offline
Administrator
 
Join Date: Oct 2007
Posts: 331
Default Setting the $ Character in Superscript for Prices

Copy and paste everything below this line:

This rule automatically superscript the dollar sign for pricing. Prior to using this rule, you need to set the superscript offset and ratio values in the Global Paragraph Settings dialog box. To do this:
  1. Double-click any text frame and click the Edit Text… button.
  2. In the Variable Text Editor, click the Paragraph button.
  3. In the Paragraph Formatting dialog box, click the Global Settings… button.
Once you have set the values, change the field "Price" in this JavaScript rule to the name of the field in your data.


// set superscript font size and baseline shift in template:
// Variabe Text Editor --> Paragraph... --> Global Settings...
// Superscript (Ratio and Offset).
// Set price field name here.
priceVariable=Field("Price")

/////////
priceVariable=priceVariable.replace("$", ""); //remove dollar sign if entered by user
priceVariable=FormatNumber("##,###.00##", priceVariable); //format as price with two digits after decimal point
var dollarsCentsArray=priceVariable.split("."); //divide up dollars and cents
dollars = dollarsCentsArray[0];
cents = dollarsCentsArray[1];
//format with superscripted dollar sign/cents if dollars are entered
//or with superscripted cent sign if no dollars entered
if (dollars!="")
{
return '<superscript>'+"$"+'</superscript>'+dollars+'<superscript>'+cents+'</superscript>';
}
else
{
return cents+'<superscript>'+"¢"+'</superscript>';
}
__________________
Forum Administrator
PTI Marketing Technologies, Inc.
Reply With Quote