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:

view plain print about

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

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

Parameters:

Name	Description	Required
strVal	Value to convert.	Yes

Full UDF Source:

	
	
			
			
			
				
				view plain
				
				
				copy to clipboard
				
				
				
				
				print
				
				
				about
				ColdFISH is developed by Jason Delmore.  Source code and license information available at coldfish.riaforge.org.  Version 3.1.1
				
			<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 (&#103;&#108;&#101;&#110;&#110;&#46;&#119;&#105;&#108;&#115;&#111;&#110;&#64;&#113;&#117;&#111;&#116;&#101;&#103;&#101;&#110;&#46;&#99;&#111;&#109;) 
 * @version 1, November 15, 2002 
 */
function Convert2Number(StrVal){
  var regStr = "[^/.0123456789-]";
  return Val(REReplace(StrVal,regStr,"","all"));
}
</cfscript>
		<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>