Description

Converts numeric characters that occur at the beginning of a string to a number.

Returns

A number. If conversion fails, returns zero.

Category

Conversion functionsString functions

Function syntax

Val(string)

See also

IsNumeric

Parameters

Parameter

Description

string

A string or a variable that contains one

Usage

This function works as follows:

  • If TestValue = "234A56?7'", Val(TestValue) returns 234.
  • If TestValue = "234'5678'9?'", Val(TestValue) returns 234.
  • If TestValue = "BG234", Val(TestValue) returns the value 0, (not an error).
  • If TestValue = "0", Val(TestValue) returns the value 0, (not an error).

Example

<cfif IsDefined("FORM.theTestValue")> 
<cfif Val(FORM.theTestValue) is not 0> 
<h3>The string <cfoutput>#DE(FORM.theTestValue)#</cfoutput> 
can be converted to a number: 
<cfoutput>#Val(FORM.theTestValue)#</cfoutput></h3> 
<cfelse> 
<h3>The beginning of the string <cfoutput>#DE(FORM.theTestValue)# 
</cfoutput> cannot be converted to a number</h3> 
</cfif> 
</cfif> 
<form action = "val.cfm"> 
<p>Enter a string, and determine whether its beginning can be evaluated 
to a numeric value. 
<p> 
<input type = "Text" 
name = "TheTestValue" 
value = "123Boy"> 
<input type = "Submit" 
value = "Is the beginning numeric?" 
name = ""> 
</form>

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License  Twitter™ and Facebook posts are not covered under the terms of Creative Commons.

Legal Notices   |   Online Privacy Policy