1.3.11.9 Convert Number to String
The Convert Number to String transformer takes any number of Number or Number Array attributes and converts them to a String or String Array type respectively.
Use Convert Number to String where you want to treat a number as text for processing purposes, or because you are migrating data to a target system with a different data type, for example where telephone numbers are stored as text fields rather than numbers.
The following table describes the configuration options:
| Configuration | Description |
|---|---|
|
Inputs |
Specify any Number or Number Array of Number attributes that you want to convert to a String or String Array type. |
|
Options |
None. |
|
Outputs |
Describes any data attribute or flag attribute outputs. |
|
Data Attributes |
For each attribute input, a new attribute is created in the following format:
|
|
Flags |
None. |
The Convert Number to String transformer presents no summary statistics on its processing. In the Data view, each input attribute is shown with its new derived String type attribute to the right.
Output Filters
None.
Example
In this example, Convert Number to String is used to convert AREA_CODE and TEL_NO attributes to a String format in preparation for migration to a single text-based HOME_TEL field in the target system:
| AREA_CODE | AREA_CODE.NumberToString | TEL_NO | TEL_NO.NumberToString |
|---|---|---|---|
|
0 |
0 |
508341 |
508341 |
|
1133 |
1133 |
349597 |
349597 |
|
1133 |
1133 |
717299 |
717299 |
|
1133 |
1133 |
704790 |
704790 |
|
1133 |
1133 |
618464 |
618464 |
|
1133 |
1133 |
877808 |
877808 |
|
1133 |
1133 |
969155 |
969155 |
|
1133 |
1133 |
693764 |
693764 |