CFLib.org – Common Function Library Project

Convert2Number(strVal)

Last updated November 15, 2002
Download UDF

author

Glenn Wilson                                      Glenn Wilson

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>

Search CFLib.org


Latest Additions

Shawn Porter Shawn Porter added
DeMoronize
3 hour(s) ago

Chris Carey Chris Carey added
readPropertiesFi...
1 day(s) ago

Randy Johnson Randy Johnson added
lastDayofWeek
3 day(s) ago

Frank Marion Frank Marion added
sitemapPing
7 day(s) ago

Top Rated

James Sleeman                                     QuickSort
Rated 5.0, 3 time(s)

Barney Boisvert indentXml
Rated 5.0, 3 time(s)

Nathan Dintenfass                                 queryColumnsToSt...
Rated 5.0, 3 time(s)

Kevin Pepperman generateSsccAsn
Rated 5.0, 3 time(s)

Created by Raymond Camden / Design by Justin Johnson