CFLib.org – Common Function Library Project

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:

Full UDF Source:

/**
 * 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"));
}