Parse Number from String

Last updated on Apr 24, 2026
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.

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
Apr-24-2026 NA Restructured and updated page content for accuracy and clarity.
Jan-04-2023 NA Enhanced the content for clarity.
Nov-10-2022 NA Created as a new document.

Tell us what went wrong