transformations:exporttext
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
transformations:exporttext [2015/10/01 22:01] – dmitry | transformations:exporttext [2019/01/10 11:35] – dmitry | ||
---|---|---|---|
Line 1: | Line 1: | ||
===== Export into delimited text file ===== | ===== Export into delimited text file ===== | ||
- | This transformation exports table into a delimited text file. | + | This transformation exports table into a delimited text file. The file name can use either full or relative path. It can also be specified using a [[: |
- | File name can use either full or relative path. | + | By default, when the file name has no extension, the action automatically appends extension " |
+ | ===Options=== | ||
+ | |||
+ | ==Export modes== | ||
+ | * Create new file - create new file or overwrite existing file with the same name | ||
+ | * Append to file - append dataset to existing file (the row with headers will not be appended). Note that the operation doesn' | ||
+ | |||
+ | ==Wrap in quotes== | ||
+ | * 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 - 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 with care. | ||
+ | |||
+ | ==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.txt · Last modified: 2021/07/19 02:08 by craigt