PowerCenter
- PowerCenter 10.5
- All Products
' 100 ' ' +100' '-100' '-3.45e+32' '+3.45E-32' '+3.45d+32' (Windows only) '+3.45D-32' (Windows only) '.6804'
IS_NUMBER(value)
Argument
| Required/
Optional
| Description
|
---|---|---|
value
| Required
| Must be a String datatype. Passes the rows you want to evaluate. You can enter any valid transformation expression.
|
IS_NUMBER( ITEM_PRICE )
|
|
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
IIF( IS_NUMBER ( ITEM_PRICE ), TO_FLOAT( ITEM_PRICE ), 0.00 )
|
|
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|