Differences

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

--- transformations:exporttext [2015/10/01 22:01] – dmitry
+++ transformations:exporttext [2018/05/09 21:02] – dmitry
@@ Line 1: / Line 1: @@
 ===== 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 [[:parameters|parameter]].
-File name can use either full or relative path.
+===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't change order of columns in appended dataset, even if columns in the existing file are in different order. If the file doesn't exist it will be created automatically (the row with headers will be inserted first).
+==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't write column headers==
+Don't write into the file a row with column headers.
+==Preserve formatting==
+Export number values (including dates) using the currently selected column format.