Differences

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

--- transformations:filesplitter [2021/07/19 01:51] – [Examples] craigt
+++ transformations:filesplitter [2022/12/04 16:34] (current) – [Action settings] dmitry
@@ Line 13: / Line 13: @@
 |Encoding|ASCII, ANSI (with code page), and other types of encoding. If you're not sure what to choose, try UTF-8 as it's the most\\ common Unicode encoding.|
 |Skip first lines<sup>*</sup>|This option specifies how many lines to skip from the beginning of a file. It can be helpful in cases where the first rows contain\\ some metadata (file header) and actual tabular data starts only after that metadata. This setting can be specified\\ using a parameter as well.|
+|Ignore quoting | When checked, double quotes are treated like a regular character. |
 |Output folder<sup>*</sup>|The folder location the split files will be saved to.|
 |Output mode|The method by which the input file will be split.\\Options: //Split by fixed row count// (define the number of rows), or\\ //Split by column value// (define delimiter and column)|
@@ Line 33: / Line 34: @@
 **Example 1:**  Splitting a comma-delimited text file with 10,000 rows, and splitting every 1,000 rows.\\
+\\
 **Action parameters:**
 >  (Split by fixed row count) Chunk size (rows) is 1000\\
 \\
-**Output:**
+**Results:**
   * 10 1000-row files with "00000001" through "00000010" appended to the filenames
   * A workflow dataset containing the fully qualified filenames of the split files.
@@ Line 42: / Line 45: @@
 \\ \\
 **Example 2:**  Splitting a comma-delimited text file with 10,000 rows, and splitting by each unique Region value.\\
 \\
 **Action parameters:**
 >  (Split by column value) Separator is Comma
 >  (Split by column value) Column is Region
 \\
-**Output:**
+**Results:**
   *One file for each unique Region value, with the Region values appended to the filenames.
   * A workflow dataset containing the fully qualified filenames of the split files.