User Tools

Site Tools


transformations:convert

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
transformations:convert [2021/04/02 23:27] craigttransformations:convert [2021/08/14 21:20] – [Text to Number settings] craigt
Line 44: Line 44:
 ^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====
Line 84: Line 85:
 |  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//)
  
 \\  \\ 
transformations/convert.txt · Last modified: 2023/10/05 17:01 by dmitry

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki