Format Number to String
| Description: | Format numbers to strings. |
| Available Filters: | Event Filters: - Event Type - Event Field Field Filters: - Field Name - Field Value |
| Settings: |
String Format: This can be: - Plain Text (“123456”) - Number (1,23,456) - Percent (12345600 %) E.g. 123.456 is multiplied by 100 and rounded up to the nearest integer as 12346% - Scientific (1.01E + 12) - Currency ($ 1,23,456.00). Currently, only USD is supported. - Custom |
| Transformation Considerations: | None. |
Sample Transformation
Scenario: Change the format of the values in the Salary field for all Events of the Employee Event Type to add a comma at each place value, as per the US numeration style.
Filters:
- Event Type =
Employee - Fields = All fields with name =
Salary
Settings:
- String Format =
Number
Result: When you test the Transformation, the value 65000 in the Salary field is changed to the Number format as 65,000.
Last updated on May 30, 2023