How to convert a string representation of a number to a number in coldfusion?

coldfusion cfml
Scott Chantry picture Scott Chantry · Jan 25, 2010 · Viewed 51.2k times · Source

I want to be able to convert a string number such as "1,427.76" to a number in coldfusion but the comma is making it fail. Is there a simple way to do it besides having to remove the comma?

<cfset string = "1,427.75">

<cfset number = string * 100>

The error occurs when trying to perform mathematical operations on it. If the comma is removed it works just fine but I'm getting the comma from a database calculation.

Answer

derivation picture derivation · Jan 25, 2010

I know you can use LSParseNumber:

<cfset string = "1,427.75">

<cfset number = LSParseNumber(string) * 100>

Related questions

Can I get a query row by index in ColdFusion?

I want to get a specific row in a ColdFusion Query object without looping over it. I'd like to do something like this: <cfquery name="QueryName" datasource="ds"> SELECT * FROM tablename </cfquery> <cfset x = QueryName[5]&…

Read More
Select one column DISTINCT SQL

Added: Working with SQL Server 2000 and 2005, so has to work on both. Also, value_rk is not a number/integer (Error: Operand data type uniqueidentifier is invalid for min operator) Is there a way to do a single column "DISTINCT" …

Read More
Coldfusion: How to split a string into a set of variables

I'm trying to teach myself ColdFusion. I have a string coming in from the database in this format: domain.com <br/> www.facebook.com/facebookpage <br/> http://instagram.com/instagrampage It is all coming from #getRacer.…

Read More