CFLib.org – Convert2Number

Convert2Number(strVal)

Last updated November 15, 2002

author

Version: 1 | Requires: ColdFusion 5 | Library: MathLib

Rated 0 time(s). Average Rating: 0

Description:
This function will take any string and strip out all characters that are not (-.0123456789) and will then determine it's numeric value.

Return Values:
Returns a number.

Example:

Convert2Number($3,456.78) will return the numeric value 3456.78

Parameters:

Name	Description	Required
strVal	Value to convert.	Yes

Full UDF Source:

	
	<cfscript>
/**
 * Converts any numeric string (even ones with currancy symbols to a number).
 * 
 * @param strVal      Value to convert. (Required)
 * @return Returns a number. 
 * @author Glenn Wilson (glenn.wilson@quotegen.com) 
 * @version 1, November 15, 2002 
 */
function Convert2Number(StrVal){
  var regStr = "[^/.0123456789-]";
  return Val(REReplace(StrVal,regStr,"","all"));
}
</cfscript>