Unstructured Text
List to Comma Separated
Join the lines of a list into one line, separated by commas or any separator you choose.
When to use it
Typical uses: Building SQL IN (…) clauses; Pasting spreadsheet columns into tag or keyword fields; Creating arrays for code.
In a pipeline
Text InputList to Comma SeparatedText Output
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Text column | select | — | Text |
| Separator | text | — | , |
| Wrap each item in double quotes (CSV style) | checkbox | — | false |
| Generate New Column | checkbox | — | false |
| New Column Name | text | — | Default: <column> Result |
| Insert After | select | — | After the column |
| When a value cannot be converted | select | — | stop |
Example
List to Comma Separated: an example
- Wrap each item in double quotes (CSV style)=Ticked
| Text |
|---|
| London Paris New York Tokyo |
| Text |
|---|
| "London", "Paris", "New York", "Tokyo" |
Worth knowing
- Can I use a separator other than a comma? Yes. Type any separator, such as “; ”, “ | ” or a single space.
- Are empty lines included? No. Blank lines are skipped.
- How do I convert back? Use Comma Separated to List.
- Works on any text column, not only Text Input's: pick it under Text column. Tick Generate New Column to keep the original next to the result.