TextToNumber

Converts the value in a text token to a number. Numeric Modifiers can then be applied to the result. See Numeric Modifiers.

An example is:

•Original token: 12345

•Modifier: Text to Number

•Result: 12345 (now available for Numeric Modifiers)

Syntax

TextToNumber(textValue)

Enabled For

For a description of the business object categories, see Notes on "Enabled For".

Business Object Category	Yes/No
Business Rules: Before-Save Rules	Yes
Business Rules: Calculation Rules (After Save, with or without Also Recalculate on Load)	Yes1
Business Rules: Calculation Rules (Before Save or Always, without Also Recalculate On Load)	Yes
Business Rules: Calculation Rules (Before Save or Always, with Recalculate On Load)	Yes1
Business Rules: Editing Rules	Yes
Business Rules: Initialization Rules	Yes
Business Rules: Read Only Rules	Yes
Business Rules: Required Rules	Yes
Business Rules: Validation Rules	Yes
Client Expressions	Yes
Object Permissions	No
Services	No
LDAP	No
Mobile	No
Quick Actions (except UI Quick Actions)	Yes
UI Quick Actions	Yes
Reports	Yes
Search/Dashboard without field references	No
Search/Dashboard with field references	No
1. Not fully supported in calculation rules that have a condition of After Save or the Also Recalculate on Load option selected. It may fail if the rule's field is used in a grid, form, or saved search.

Parameters

Parameter	Description
textValue	Input string to convert from text value to a number

Return Value

Returns a number for a text value.

Example

$(TextToNumber('12345'))

Returns this value: 12345