transformations:exportplaintext
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
transformations:exportplaintext [2021/01/16 10:08] – created dmitry | transformations:exportplaintext [2023/03/08 13:59] (current) – updates for v5.4.1 - append mode craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Export | + | {{ transformations: |
+ | ======EXPORT AS PLAIN TEXT====== | ||
+ | Category: | ||
+ | |||
+ | \\ | ||
+ | =====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 | ||
+ | |File< | ||
+ | |Column | ||
+ | |Decimal|Select the character used within numeric values to define decimal places. | ||
+ | |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 // | ||
+ | |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' | ||
+ | < | ||
+ | \\ | ||
+ | ====File already exists options==== | ||
+ | ^Option ^Description ^ | ||
+ | |Overwrite|The new file replaces the original file.| | ||
+ | |Rename|The original file will be renamed with " | ||
+ | |Halt project execution|The project will stop processing and this action will display a warning symbol.| | ||
- | Export | + | \\ |
+ | =====Advanced options===== | ||
+ | ^ Setting | ||
+ | |Encoding|Select | ||
+ | |Don't write BOM|When checked, the byte order mark is not written to the output file. See [[https:// | ||
+ | |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 | ||
+ | |Preserve formatting| Export number values (including dates) using the currently selected column format. | | ||
+ | \\ | ||
+ | ====Wrap | ||
+ | ^Option ^Description ^ | ||
+ | |Auto|Only values that contain the chosen separator or a line break, or numeric values data-typed as text, will be wrapped in double-quotes. | ||
+ | |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. | ||
- | Action settings: | + | \\ |
- | ^ Settings | + | =====Community examples===== |
- | | Column | + | |
- | | File | The path to the target file. Can be specified using a parameter. | + | |
- | | Encoding | + | \\ |
- | | Don't write BOM | + | =====See also===== |
- | | Decimal | + | * [[transformations: |
- | | Export the column header too | + | |
- | | 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: | ||
- | * [[transformations: |
transformations/exportplaintext.txt · Last modified: 2023/03/08 13:59 by craigt