transformations:exporttext
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:exporttext [2019/01/10 11:35] – dmitry | transformations:exporttext [2021/07/19 02:08] (current) – [Examples] craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Export into delimited text file ===== | + | {{ transformations: |
+ | ======EXPORT INTO DELIMITED TEXT FILE====== | ||
+ | Category: Export / File\\ | ||
- | This transformation | + | \\ |
+ | =====Description===== | ||
+ | This action | ||
- | By default, when the file name has no extension, the action automatically appends extension " | + | \\ |
+ | =====Use cases===== | ||
+ | Create a plain-text, unformatted data file (such as CSV file) to exchange data with a wide variety of applications and services.\\ | ||
- | ===Options=== | + | \\ |
+ | =====Action settings===== | ||
+ | ^ Setting | ||
+ | |File< | ||
+ | |Separator|Select the delimiting character used to define columns in the exported file. | ||
+ | |Decimal|Select the character used within numeric values to define decimal places. | ||
+ | |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 " | ||
+ | < | ||
+ | \\ | ||
+ | ====Export mode options==== | ||
+ | ^Option ^Description ^ | ||
+ | |Create new file|Create a new file or overwrite an existing file with the same name. See the "File already exists options" | ||
+ | |Append to file (or create)|Append the dataset to an existing file (the header row will not be appended) or create a new file if it does not\\ already exist. | ||
+ | \\ | ||
+ | ====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.| | ||
+ | \\ | ||
+ | \\ | ||
+ | =====Advanced options===== | ||
+ | ^ Setting | ||
+ | |Encoding|Select the encoding format to use for the exported file. If you're not sure what to choose, try 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:// | ||
+ | |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 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. | ||
- | ==Export modes== | + | \\ |
- | * Create new file - create new file or overwrite existing file with the same name | + | =====Remarks===== |
- | * Append to file - append dataset to existing file (the row with headers will not be appended). Note that the operation doesn' | + | By default, when the file name has no extension, |
- | ==Wrap in quotes== | + | The " |
- | * Auto - only values that contain a space, the chosen separator, or a line break will be wrapped in double quotes. The rest won't. | + | |
- | * Everything | + | Use caution when selecting " |
- | * Nothing - no values will be wrapped in double quotes, even if they contain spaces, separators or line breaks. Use with care. | + | |
+ | \\ | ||
+ | =====Examples===== | ||
+ | |||
+ | **Source table:** | ||
+ | ^RecID ^FName ^LName ^Address ^City ^RegionState ^Zip ^ | ||
+ | | 1001|Meghan | ||
+ | | 1002|Demetria | ||
+ | | 1003|Karyn | ||
+ | | 1004|Steel | ||
+ | | 1005|Mohammad | ||
+ | | 1006|Lance | ||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > Separator is " | ||
+ | > Wrap in quotes is "Auto" | ||
+ | \\ | ||
+ | **Result data:** | ||
+ | < | ||
+ | RecID, | ||
+ | 1001, | ||
+ | 1002, | ||
+ | 1003, | ||
+ | 1004, | ||
+ | 1005, | ||
+ | 1006, | ||
+ | </ | ||
+ | The first record' | ||
+ | All Zip values are quoted as they are numeric values that have been re-typed as text.\\ | ||
+ | |||
+ | \\ | ||
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
- | ==Don' | ||
- | Don't write into the file a row with column headers. | ||
- | ==Preserve formatting== | ||
- | Export number values (including dates) using the currently selected column format. |
transformations/exporttext.1547138152.txt.gz · Last modified: 2019/01/10 11:35 by dmitry