Parse Number from String

Last updated on May 30, 2023

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

Filters:

Settings:
None.

Parse number from string settings

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

Parse number from string

Revision History

Refer to the following table for the list of key updates made to this page:

Date	Release	Description of Change
Jan-04-2023	NA	Enhanced the content for clarity.
Nov-10-2022	NA	Created as a new document.

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.