Difference between revisions of "SsParseNum"

From SmartWiki
Jump to: navigation, search
Line 39: Line 39:
 
This function is part of the <b>sstools.js</b> library and needs to be added to [[Browser Script]] custom fields or on template pages, sign-up pages etc. using the following syntax:
 
This function is part of the <b>sstools.js</b> library and needs to be added to [[Browser Script]] custom fields or on template pages, sign-up pages etc. using the following syntax:
 
  <SCRIPT type="text/javascript" language="javascript" src="/sstools.js"></SCRIPT>
 
  <SCRIPT type="text/javascript" language="javascript" src="/sstools.js"></SCRIPT>
 +
 +
==When Using "Show Currency Format in Edit Mode"==
 +
When using the "Show Currency Format in Edit Mode" setting for custom fields, the following syntax must be used:
 +
 +
:<font size="3">'''ssParseNumByCode( ''value'',''emptyok'',' ''code'' ');''' </font>
 +
 +
Where: <br / >
 +
 +
{| border="1"
 +
!Parameter
 +
!Description
 +
|-
 +
|<b><em>value </em></b>
 +
|Required. Is the value to be converted to a number (i.e: $5,000.00 and 5,000% will be converted to 5000)<br />
 +
|-
 +
|<b><em>emptyok </em></b>
 +
|Optional. Is a true/false value
 +
:*if ''emptyok'' is true - an empty string will be returned by ssParseNumByCode if the value is ''empty''
 +
:*if ''emptyok'' is false - a "0" will be returned by ssParseNumByCode if the value is ''empty''
 +
|-
 +
|<b><em>code</em></b>
 +
|Required. The three-letter currency code defined by [http://en.wikipedia.org/wiki/ISO_4217 ISO 4217]. Example: ''JPY'' for Japanese Yen.
 +
|}
  
  

Revision as of 11:32, 10 June 2014

This feature uses JavaScript syntax
Text code javascript.gif

Overview

To convert a number from a formatted string (containing symbols like "$" or "%") to a number using JavaScript you can use a function called ssParseNum.

Syntax

ssParseNum( value, emptyok );

Where:

Parameter Description
value Required. Is the value to be converted to a number (i.e: $5,000.00 and 5,000% will be converted to 5000)
emptyok Optional. Is a true/false value
  • if emptyok is true - an empty string will be returned by ssParseNum if the value is empty
  • if emptyok is false - a "0" will be returned by ssParseNum if the value is empty

Examples

ssParseNum($5,000.50);

Will return: 5000.5


If you wish to display a ratio of two fields that are set to have currency formatting, you should convert the values to numbers using ssParseNum:

ssParseNum([field1])/ssParseNum([field2])

Requirements

This function is part of the sstools.js library and needs to be added to Browser Script custom fields or on template pages, sign-up pages etc. using the following syntax:

<SCRIPT type="text/javascript" language="javascript" src="/sstools.js"></SCRIPT>

When Using "Show Currency Format in Edit Mode"

When using the "Show Currency Format in Edit Mode" setting for custom fields, the following syntax must be used:

ssParseNumByCode( value,emptyok,' code ');

Where:

Parameter Description
value Required. Is the value to be converted to a number (i.e: $5,000.00 and 5,000% will be converted to 5000)
emptyok Optional. Is a true/false value
  • if emptyok is true - an empty string will be returned by ssParseNumByCode if the value is empty
  • if emptyok is false - a "0" will be returned by ssParseNumByCode if the value is empty
code Required. The three-letter currency code defined by ISO 4217. Example: JPY for Japanese Yen.


See Also