Progress
Report Builder
User’s Guide


NUMERIC

Converts character representation of numbers into numeric values (that is, changes the data type from CHARACTER to NUMERIC). This function is the opposite of STRING.

SYNTAX

NUMERIC ( expression ) 

expression

A character expression (a constant, field name, or expression that results in a character string) that is the character representation of a number.

NOTE

NUMERIC ignores leading spaces.

EXAMPLE

To convert the street number portion of the Address field to a numeric value, create a calculated field containing this expression:

INTEGER(NUMERIC(Entry(1, Address, " "))) 

Sample data:

Address          INTEGER(NUMERIC(Entry(1, Address, " ")))
276 North Street                   276
Rattipolku                        ????
Suite 4165                        ????
66 Homer Ave                        66 

To extract the numeric portion of the character field Available, where Available represents the quantity on hand prefixed by the warehouse in which the item is stored, create a calculated field containing this expression:

INTEGER(NUMERIC(SUBSTRING(Available, 3))) 

Sample data:

Available           INTEGER(NUMERIC(SUBSTRING(Available, 3))
A-105                              105
C-254                              254
D-3                                  3 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095