User Tools

Site Tools


transformations:exporttext

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
transformations:exporttext [2021/05/06 22:29] craigttransformations:exporttext [2021/07/19 02:08] (current) – [Examples] craigt
Line 6: Line 6:
 =====Description===== =====Description=====
 This action exports a table into a delimited text file. The file name can use either a full or relative path. This action exports a table into a delimited text file. The file name can use either a full or relative path.
- 
-By default, when the file name has no extension, the action automatically appends the extension ".csv" to it.\\ 
  
 \\  \\ 
 =====Use cases===== =====Use cases=====
-Create a plain-text, unformatted data file for use with a wide variety of applications and services.\\+Create a plain-text, unformatted data file (such as CSV file) to exchange data with a wide variety of applications and services.\\
  
 \\  \\ 
Line 19: Line 17:
 |Separator|Select the delimiting character used to define columns in the exported file.  Options:  //Comma//, //Semicolon//, //Tab//, //Pipe//,\\ //Tilde//, //Space//, //Custom// (and select from the editor window), or //No separator//. | |Separator|Select the delimiting character used to define columns in the exported file.  Options:  //Comma//, //Semicolon//, //Tab//, //Pipe//,\\ //Tilde//, //Space//, //Custom// (and select from the editor window), or //No separator//. |
 |Decimal|Select the character used within numeric values to define decimal places.  Options:  //Point// or //Comma//.| |Decimal|Select the character used within numeric values to define decimal places.  Options:  //Point// or //Comma//.|
-|Export mode|Select whether this action will create a new file, or append to an existing file.  See the table below for details|+|Export mode|Select whether this action will create a new file, or append to an existing file.  See the table below for details.|
 |File already exists|When selecting to "Create new file" in the option above, choose whether to overwrite the existing file, rename the\\ existing file, or halt the action's execution.  See the "File already exists options" table below for details.| |File already exists|When selecting to "Create new file" in the option above, choose whether to overwrite the existing file, rename the\\ existing file, or halt the action's execution.  See the "File already exists options" table below for details.|
 <sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\ <sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\
Line 51: Line 49:
 \\  \\ 
 =====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).\\
  
Line 71: Line 71:
 > 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
Line 83: Line 83:
 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//)
  
 \\  \\ 
transformations/exporttext.txt · Last modified: 2021/07/19 02:08 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki