Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision |
transformations:convert [2021/04/02 23:27] – craigt | transformations:convert [2023/10/05 17:00] – [Text to Date settings] dmitry |
---|
====Text to Date settings==== | ====Text to Date settings==== |
^Setting^Description^ | ^Setting^Description^ |
|Format<sup>*</sup>|Enter the date format the current text dates are using (e.g. yyyy-MM-dd). Use the //Detect// button to populate this field with any date formats found within the column.| | |Format<sup>*</sup>|Enter the date format the current text dates are using (e.g. yyyy-MM-dd). Use the //Detect// button to populate this field with the date format found within the column. If the auto-detection didn't work, compose the [[syntax:functions:format|format string]] manually.| |
<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\ | <sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\ |
\\ | \\ |
^Setting^Description^ | ^Setting^Description^ |
|Decimal separator|Select what character is used to define decimal places in the source text values. Options: //Point// or //Comma//.| | |Decimal separator|Select what character is used to define decimal places in the source text values. Options: //Point// or //Comma//.| |
| |Thousand separator|Select what character is used to define thousands places in the source text values. Options: //Default//, //Comma//,\\ //Point// or //Space//.| |
\\ | \\ |
====Everything to Text settings==== | ====Everything to Text settings==== |
| 1'000.00 | 5500 |5,500.00 | | | 1'000.00 | 5500 |5,500.00 | |
| yyyy/MM/dd | 22335 |1961/02/23 | | | yyyy/MM/dd | 22335 |1961/02/23 | |
| |
| \\ |
| ====Community examples==== |
| * [[https://community.easymorph.com/t//1587/7|How to format the duration in more than 24h]] ([[https://community.easymorph.com/uploads/short-url/w6CnxwiidYjcJHNRrmUIXI74NC2.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //3//) |
| * [[https://community.easymorph.com/t//2166/2|Date condition for specific dates]] ([[https://community.easymorph.com/uploads/short-url/hEAQZ5dAEMQk2xUZVJucAo2kJTz.morph|Project]]; Module: //Main//; Group: //Group 1//; Table: //TR101.xlsx//; Action position: //2//) |
| * [[https://community.easymorph.com/t//2292/2|Assign value from conditions based on a table]] ([[https://community.easymorph.com/uploads/short-url/hsFachkdfbcKFoA2ZK8WcmOUfA9.morph|Project]]; Module: //Main//; Group: //Group 1//; Table: //Table 1//; Action position: //4//) |
| * [[https://community.easymorph.com/t//2297/2|Excel: Import Date Headings as number]] ([[https://community.easymorph.com/uploads/short-url/ppgiXxeiQbK0O3owwca3pxAsOyH.morph|Project]]; Module: //Main//; Group: //Group 1//; Table: //New header//; Action position: //3//) |
| |
\\ | \\ |