transformations:convert
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:convert [2021/07/18 01:04] – craigt | transformations:convert [2023/10/05 17:01] (current) – [Text to Date settings] dmitry | ||
---|---|---|---|
Line 38: | Line 38: | ||
====Text to Date settings==== | ====Text to Date settings==== | ||
^Setting^Description^ | ^Setting^Description^ | ||
- | |Format< | + | |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' | ||
+ | |||
+ | :!: The specifiers below are case-sensitive. | ||
+ | ^ 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==== | ====Text to Number settings==== | ||
^Setting^Description^ | ^Setting^Description^ | ||
|Decimal separator|Select what character is used to define decimal places in the source text values. | |Decimal separator|Select what character is used to define decimal places in the source text values. | ||
+ | |Thousand separator|Select what character is used to define thousands places in the source text values. | ||
\\ | \\ | ||
====Everything to Text settings==== | ====Everything to Text settings==== |
transformations/convert.txt · Last modified: 2023/10/05 17:01 by dmitry