Both sides previous revisionPrevious revisionNext revision | Previous revision |
transformations:exporttext [2021/05/14 04:36] – [Description] dmitry | transformations:exporttext [2021/07/19 02:08] (current) – [Examples] craigt |
---|
\\ | \\ |
=====Remarks===== | =====Remarks===== |
| By default, when the file name has no extension, the action automatically appends the extension ".csv" to it. |
| |
The "Append to file" operation doesn't change the order of the columns in the appended dataset, even if columns in the existing file are in a different order. If the file doesn't exist, it will be created automatically (the row with headers will be inserted first, in this case).\\ | The "Append to file" operation doesn't change the order of the columns in the appended dataset, even if columns in the existing file are in a different order. If the file doesn't exist, it will be created automatically (the row with headers will be inserted first, in this case).\\ |
| |
> Wrap in quotes is "Auto" | > Wrap in quotes is "Auto" |
\\ | \\ |
**Result:** | **Result data:** |
<code> | <code> |
RecID,FName,LName,Address,City,RegionState,Zip | RecID,FName,LName,Address,City,RegionState,Zip |
The first record's Address is enclosed in quotes since it contains a comma, which is the designated delimiter.\\ | The first record's Address is enclosed in quotes since it contains a comma, which is the designated delimiter.\\ |
All Zip values are quoted as they are numeric values that have been re-typed as text.\\ | All Zip values are quoted as they are numeric values that have been re-typed as text.\\ |
| |
| \\ |
| ====Community examples==== |
| * [[https://community.easymorph.com/t//1629/2|In case, no file to load]] ([[https://community.easymorph.com/uploads/short-url/4OREDaUn1vdfwxKOGmMoLXAl7CB.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Create it, if it doesn't//; Action position: //3//) |
| * [[https://community.easymorph.com/t//1876/2|How to report validation failures?]] ([[https://community.easymorph.com/uploads/short-url/x8xqV8QqQbnnI467dxWdhLbXnFr.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Process invalid rows//; Action position: //2//) |
| * [[https://community.easymorph.com/t//2660/7|Conditional execution]] ([[https://community.easymorph.com/uploads/short-url/qSgHAXCrkqD6AtLLp5ZOlOv1vIG.morph|Project]]; Module: //Main//; Group: //Group 2//; Table: //Table2//; Action position: //3//) |
| |
\\ | \\ |