[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
``` VAL()
Convert a character number to numeric type
------------------------------------------------------------------------------
Syntax

VAL(<cNumber>) --> nNumber

Arguments

<cNumber> is the character expression to be converted.

Returns

VAL() returns <cNumber> converted to a numeric value including decimal
digits.

Description

VAL() is a character conversion function that converts a character
string containing numeric digits to a numeric value.  When VAL() is
executed, it evaluates <cNumber> until a second decimal point, the first
non-numeric character, or the end of the expression is encountered.
Leading spaces are ignored.  When SET FIXED is ON, VAL() returns the
number of decimal places specified by SET DECIMALS, rounding <cNumber>
if it is specified with more digits than the current DECIMALS value.  As
with all other functions that round, digits between zero and four are
rounded down, and digits between five and nine are rounded up.  When SET
FIXED is OFF, VAL() returns the number of decimal places specified in
<cNumber>.

VAL() is the opposite of STR() and TRANSFORM(), which convert numeric
values to character strings.

Examples

.  These examples illustrate VAL() with SET FIXED ON and SET
DECIMALS TO 2:

SET DECIMALS TO 2
SET FIXED ON
//
? VAL("12.1234")         // Result:   12.12
? VAL("12.1256")         // Result:   12.13
? VAL("12A12")           // Result:   12
? VAL("A1212")           // Result:      0
? VAL(SPACE(0))          // Result:      0
? VAL(SPACE(1))          // Result:      0
? VAL(" 12.12")          // Result:   12.12

Files   Library is CLIPPER.LIB.

```

See Also: ROUND() SET DECIMALS SET FIXED STR() TRANSFORM()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson