User Tools

Site Tools


transformations:exportplaintext

Differences

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

Link to this comparison view

Next revision
Previous revision
transformations:exportplaintext [2021/01/16 10:08] – created dmitrytransformations:exportplaintext [2023/03/08 13:59] (current) – updates for v5.4.1 - append mode craigt
Line 1: Line 1:
-===== Export plain text =====+{{ transformations:ExportPlainTextAction.png}} 
 +======EXPORT AS PLAIN TEXT====== 
 +Category: Export / File\\ 
 +  
 +\\  
 +=====Description===== 
 +Export the contents of a column into a text file, as is. Each column value is exported as text into one line of the file.\\ 
 +  
 +\\  
 +=====Use cases===== 
 + Most frequently, this action is used to create text files in a format not natively supported by EasyMorph.\\ 
 +  
 +\\  
 +=====Action settings===== 
 +^ Setting  ^ Description 
 +|File<sup>*</sup>|Enter a fully-qualified file name for the output file (includes relative or absolute path).| 
 +|Column  | Select the column to export into the target text file.  | 
 +|Decimal|Select the character used within numeric values to define decimal places.  Options: //Point// or //Comma//.| 
 +|Export mode|Choose whether the action will create a new file or append to an existing file.  Options: //Create new file// or //Append to file (or create)// (appends to the file if it already exists, or creates the file if it //doesn't// exist).| 
 +|File already exists|If a file with the same name already exists, 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]].\\ 
 +\\  
 +====File already exists options==== 
 +^Option ^Description ^ 
 +|Overwrite|The new file replaces the original file.| 
 +|Rename|The original file will be renamed with "backup" and a serial number appended to the file name.  The new file will\\ possess the name specified in the //File// setting.| 
 +|Halt project execution|The project will stop processing and this action will display a warning symbol.|
  
-Export the contents of a column into a text file, as is. Each column value is exported as text into one line of the file. Most frequently, the action is used to create text files in a format not natively supported by EasyMorph.+\\  
 +=====Advanced options===== 
 +^ Setting  ^ Description 
 +|Encoding|Select the encoding format to use for the exported file. If you're not sure what to choosetry UTF-8 as it's\\ the most common Unicode encoding.| 
 +|Don't write BOM|When checked, the byte order mark is not written to the output file See [[https://en.wikipedia.org/wiki/Byte_order_mark|Wikipedia - Byte order mark]] for details. | 
 +|Wrap in quotes|Select which values are wrapped in quotation marks in the export file.  See the table below for details.| 
 +|Don't write column headers|Column headings are not written into the exported file.
 +|Preserve formatting| Export number values (including dates) using the currently selected column format. | 
 +\\  
 +====Wrap in quotes options==== 
 +^Option ^Description ^ 
 +|Auto|Only values that contain the chosen separator or line break, or numeric values data-typed as text, will be wrapped in double-quotes.  Other value types will not be.| 
 +|Everything|All values will be wrapped in double-quotes.| 
 +|Nothing|No values will be wrapped in double quotes, even if they contain spaces, separators, or line breaks.  //Use this option with care//.|
  
-Action settings: +\\ 
-^ Settings  ^ Description  ^ +=====Community examples===== 
-| Column  | The column which values are exported into the target text file | +  * [[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: //Table3//; Action position: //3//) 
-| File    | The path to the target fileCan be specified using a parameter. +  
-| Encoding   | The encoding of the target file.  | +\\  
-| Don'write BOM  Do not write the [[https://en.wikipedia.org/wiki/Byte_order_mark|byte order mark]] at the beginning of the file. +=====See also===== 
-| Decimal  | The decimal separator for numbers.  | +  * [[transformations:exporttext|Export into delimited text file]] 
-| Export the column header too  When checked, the column name will be exported as the 1st line of the target file.  | +  * [[transformations:importplaintext|Import plain text]]
-| Preserve formatting | If checked and the exported column has a format specified (e.g. for dates), use the format when exporting numbers.  |+
  
-=== See also === 
- 
-  * [[transformations:importplaintext|Import plain text]] 
-  * [[transformations:exporttext|Export into delimited text file]] 
transformations/exportplaintext.txt · Last modified: 2023/03/08 13:59 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki