Table of Contents

, ,

AS_NUMBER

Description

Converts the given string into a number. If a string cannot be converted the original string is returned.

Syntax

AS_NUMBER (text)

Can be used in the condition of a FIND action.

Parameters

Attribute of the Plain Text type or string constant or calculation producing text

Returns

Number: the number the text represents; if the text is not a number, the original text comes back unchanged

Example

IF AS_NUMBER(Account.Text)= 5 THEN ... 

AS_STRING, AS_DATE, NFORMAT