Format Number to String

Last updated on May 30, 2023
On This Page
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

Number to string

Result: When you test the Transformation, the value 65000 in the Salary field is changed to the Number format as 65,000.

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.
Was this page helpful?

Tell us what went wrong