Parse Number from String

Description:	Parse number from string value.
Available Filters:	Event Filters: - Event Type - Event Field Field Filters: - Field Name - Field Value
Settings:	None.
Transformation Considerations:	Any commas and spaces are removed from the string.

Sample Transformation

Scenario: Convert the string data in the SSN field to numeric, in all Events of the Employee Event Type.

Filters:

• Event Type = Employee
• Fields = All fields with name = SSN

Settings:
None.

Result: When you test the Transformation, the value of the SSN field is changed from String (varchar) to Number (int) format.