Parse Number from String

Last updated on May 30, 2023
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
Jan-04-2023 NA Enhanced the content for clarity.
Nov-10-2022 NA Created as a new document.

Tell us what went wrong