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.
Last updated on May 30, 2023