convertnumbers#
Convert the numerical characters in a string into a number.
Note
This guide explains how to configure the convertnumbers instruction. To learn about another instruction, go back to the Custom scripts available in Adverity overview.
Introduction#
Use the convertnumbers instruction to convert data containing numeric characters into number format.
You may need to use this instruction before other instructions that require numeric data, such as sumup. Add the convertnumbers instruction to the same custom script transformation before the instruction that requires data in numeric format.
Creating a custom script transformation using the convertnumbers instruction#
To create and configure a custom script using the convertnumbers instruction, follow these steps:
In the Configuration step, select the convertnumbers instruction.
To configure the custom script instruction, fill in the required fields below, as well as any optional fields you require:
- Fields (required)
Enter the column containing the values to convert.
- Locale (required)
Enter the locale of the numbers to convert as a two-letter ISO 639 language code. These codes are always in lower case, e.g. en for English or de for German. For a full list of codes, see ISO 639 language codes.
The converted numbers are always output in en format, i.e. 100000 instead of 100.000.
Hint
This field is case sensitive.
- Default
Enter the value to use if the conversion cannot be applied (for example, if the value to convert is not numeric characters). Enter either a number or select null.
- Strict
If selected, the value None is returned if the conversion fails.
Example#
Transformation configuration#
- Fields
Clicks- Locale
de- Default
0
Data table before transformation#
Campaign |
Clicks |
|---|---|
Brand |
175.856 |
Outreach |
238.753 |
Organic growth |
99.651 |
Retention |
No data |
Data table after transformation#
Campaign |
Clicks |
|---|---|
Brand |
175856 |
Outreach |
238753 |
Organic growth |
99651 |
Retention |
0 |