Parse node
Text to Columns
Split a text field into multiple columns or rows by a delimiter.
What it does
Splits one text column by a delimiter. Send the pieces across side-by-side columns (with an optional name and type per column) or explode them into one row each. It's the fast, no-regex way to break apart CSV-in-a-cell, tag lists, names, and paths.
Inputs and outputs
| Inputs | One. |
| Outputs | One. |
When to use it
- Break a packed field like "John,Doe,42" into separate columns
- Turn a delimited list into one row per value for grouping or joining
- Split on a set of characters at once, or on a whole multi-character delimiter
- Parse a quoted CSV field where commas hide inside quotes
Examples
Into columns
"John,Doe,42" · , · Columns (3)
Fills col1=John, col2=Doe, col3=42.
Into rows
"a;b;c" · ; · Rows
Becomes three rows, other columns copied.
Typed columns
"12,ab" · , · #1 Integer, #2 Text
col1 comes out as a real number.
Quoted CSV
a,"b,c",d · , · ignore quotes
The comma inside quotes doesn't split → a | b,c | d.
Tips
- "Any of these characters" splits on each character you type (,; splits on comma OR semicolon); "One exact string" treats the whole thing as a single delimiter (::).
- More pieces than columns? Keep the overflow in the last column, drop it, or stop with an error: your choice.
- Name & type each column to get Integer / Date / Decimal out directly; a value that won't convert becomes null. Fixed decimal also asks for its Precision (total digits, up to 38) and Scale (digits after the point).
- Escapes \t \n \r \s (space) work in the delimiter. Turn on Collapse to treat repeated delimiters (like double spaces) as one.
- A null or empty source yields empty columns (Columns) or no rows (Rows). It never fails the run.