transformations:convert
This is an old revision of the document!
Table of Contents
Convert Data Types
This transformation converts values of one type (e.g. text) to another type (e.g. number). There are 3 modes:
Text to date
In this mode text values that look like a date are converted into number dates. A date format must be specified. All text values that match the specified format are converted to number dates. For instance:
Format: M/d/yyyy
| Before (text) | After | Comment |
|---|---|---|
| 12/31/2017 | 43100 | Corresponds to December 31st, 2017. |
| 12-31-2017 | 12-31-2017 | No conversion happened as the text value didn't match the specified format. |
The format notation is the same as for the format() function.
Text to number
In this mode text values that look like a number are converted into numbers. For instance:
Decimal separator: Point
| Before (text) | After | Comment |
|---|---|---|
| 1000 | 1000 | |
| 1,000 | 1,000 | No conversion happened as the text value has different decimal separator. |
| 10.00 | 10 | |
| $1000 | $1000 | No conversion happened as the text value is not recognized as a number. |
Everything to text
In this mode text values remain unchanged and non-text values are converted into text. Numbers are formatted as per the specified format. For instance:
Number format: 100%
| Before | After (text) | Comment |
|---|---|---|
| 10 | 1000% | |
| $1000 | $1000 | No conversion happened as the value is not a number. |
| ABcd | ABcd | No conversion happened as the value is not a number. |
| TRUE | TRUE | Booleans are converted to text. |
| #Error | Error | Errors can be converted into text too. |
| 43100 | 4310000% | This value is probably a date (#2017-12-31) but since the specified number format is percentage the value was converted into percentage formatted text. A date format should've been used. |
See also
transformations/convert.1516683881.txt.gz · Last modified: 2018/01/23 00:04 by dmitry