transformations:convert
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:convert [2018/01/23 00:04] – Added "See also" dmitry | transformations:convert [2023/10/05 17:01] (current) – [Text to Date settings] dmitry | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Convert Data Types ===== | + | {{ transformations: |
- | + | ====== CONVERT DATA TYPE ====== | |
- | This transformation converts values of one type (e.g. text) to another type (e.g. number). There are 3 modes: | + | Category: Transform / Basic\\ |
+ | \\ | ||
+ | =====Description===== | ||
+ | This action converts values of one type (e.g. text) to another type (e.g. number). There are 4 modes:\\ | ||
+ | \\ | ||
====Text to date==== | ====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. | + | 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. |
+ | The format notation is the same as for the [[syntax:functions: | ||
- | Format: M/d/yyyy | + | \\ |
+ | ====Text to number==== | ||
+ | In this mode, text values that look like a number are converted into numbers.\\ | ||
- | ^ Before (text) ^ After ^ Comment ^ | + | \\ |
- | | 12/ | + | ====Everything to text==== |
- | | 12-31-2017 | + | In this mode, text values remain unchanged and non-text values are converted into text. Numbers are formatted |
- | The format notation is the same as for the [[syntax: | + | \\ |
+ | ====Empty to text or a number==== | ||
+ | In this mode, empty values are replaced with the static text or number value specified.\\ | ||
- | ====Text to number==== | + | \\ |
- | In this mode text values | + | =====Use cases===== |
+ | * Convert | ||
+ | * Convert | ||
+ | * Recode " | ||
- | Decimal separator: Point | + | \\ |
- | ^ | + | =====Action settings===== |
- | | 1000 | + | ^Setting^Description^ |
- | | 1, | + | |Columns to convert|Select the column(s) from the dataset to apply the value conversion to.| |
- | | 10.00 | 10 | | | + | |Conversion|Select |
- | | $1000 | + | |If conversion fails|Select how EasyMorph will respond when the selected conversion type cannot be applied to values.\\ Options: |
+ | \\ | ||
+ | ====Text to Date settings==== | ||
+ | ^Setting^Description^ | ||
+ | |Format< | ||
+ | < | ||
+ | \\ | ||
+ | ==== Date-Time format string components ==== | ||
+ | A //format string// defines a formatting template for dates and times. Its components can be put together in any combination. If a character doesn' | ||
- | ====Everything | + | :!: The specifiers below are case-sensitive. |
- | In this mode text values | + | ^ Date format specifier^ |
+ | | d |The day of the month, from 1 through 31. | | ||
+ | | dd |The day of the month, from 01 through 31. | | ||
+ | | ddd |The abbreviated name of the day of the week. | | ||
+ | | M |The month, from 1 through 12. | | ||
+ | | MM |The month, from 01 through 12. | | ||
+ | | MMM |The abbreviated name of the month. | ||
+ | | MMMM |The full name of the month. | ||
+ | | y |The year, from 0 to 99. | | ||
+ | | yy |The year, from 00 to 99. | | ||
+ | | yyyy |The year as a four-digit number. | ||
+ | |||
+ | ^ Time format specifier^ | ||
+ | | h |The hour, using a 12-hour clock from 1 to 12. | | ||
+ | | hh |The hour, using a 12-hour clock from 01 to 12. | | ||
+ | | H |The hour, using a 24-hour clock from 0 to 23. | | ||
+ | | HH |The hour, using a 24-hour clock from 00 to 23. | | ||
+ | | m |The minute, from 0 through 59. | | ||
+ | | mm |The minute, from 00 through 59. | | ||
+ | | s |The second, from 0 through 59. | | ||
+ | | ss |The second, from 00 through 59. | | ||
+ | | t |The first character of the AM/PM designator. | ||
+ | | tt |The AM/PM designator. | ||
+ | |||
+ | |||
+ | \\ | ||
+ | ====Text to Number settings==== | ||
+ | ^Setting^Description^ | ||
+ | |Decimal separator|Select what character is used to define decimal places in the source | ||
+ | |Thousand separator|Select what character is used to define thousands places in the source | ||
+ | \\ | ||
+ | ====Everything to Text settings==== | ||
+ | ^Setting^Description^ | ||
+ | |Number format|Select the output format for the converted text values (e.g., selecting " | ||
+ | \\ | ||
+ | ====Empty to text or number settings==== | ||
+ | ^Setting^Description^ | ||
+ | |Value< | ||
+ | < | ||
+ | |||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | |||
+ | **Text to date example: | ||
+ | |||
+ | > Format: M/d/yyyy | ||
+ | |||
+ | ^Before (text) | ||
+ | |12/31/2017 | 43100 | Corresponds to December 31st, 2017. | | ||
+ | |12-31-2017 |12-31-2017 | ||
+ | |||
+ | \\ | ||
+ | **Text to number example:** | ||
+ | |||
+ | > Decimal separator: Point | ||
+ | |||
+ | ^Before (text) | ||
+ | | 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 example: | ||
+ | |||
+ | ^Format | ||
+ | | 100% | 10|1000% | | ||
+ | | 1' | ||
+ | | yyyy/ | ||
- | Number | + | \\ |
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
- | ^ Before | + | \\ |
- | | 10 | 1000% | | | + | =====Shortcuts===== |
- | | $1000 | $1000 | No conversion happened as the value is not a number. | | + | Fast ways to create |
- | | ABcd | ABcd | No conversion | + | |
- | | TRUE | TRUE | Booleans are converted to text. | | + | |
- | |# | + | |
- | | 43100 | 4310000% | + | |
- | **See also** | + | \\ |
- | * [[syntax: | + | =====See also===== |
+ | * [[syntax: | ||
* [[syntax: | * [[syntax: | ||
* [[syntax: | * [[syntax: | ||
* [[syntax: | * [[syntax: |
transformations/convert.txt · Last modified: 2023/10/05 17:01 by dmitry