Differences

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

--- transformations:importtext [2023/10/12 00:48] – [Remarks] craigt
+++ transformations:importtext [2026/09/22 06:26] (current) – [Advanced options] added two new advanced options roberto
@@ Line 31: / Line 31: @@
 |Show parsing errors|Check this to add a column that contains parsing errors (if any) for each line. It can help detect rows that have too few values, or too many values.|
 |Ignore quoting|By default, values wrapped in double quotes can contain the separator character and line breaks. Check this option if wrapping double quotes should be treated as regular characters.|
+|Add new columns when rows have more values than headers|By default, the number of columns is defined by the header line (or the first line), and extra values in longer rows are dropped. Check this to add new columns at the end of the table for such values. Available only when //Load all columns// is selected.|
 |Maximum number of lines to load<sup>*</sup>|Limits the number of rows loaded from the file. This setting is applied after //Skip first lines//. Use "0" to load all rows.|
+|Treat numeric values|Select how values that look like numbers are imported.  Options:  //Always as numbers// (default; such values are converted to numbers), //As text when quoted// (numbers wrapped in double quotes, e.g. "00123", are kept as text), or //Always as text// (no conversion to numbers).|
 <sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\