Unstructured Text
Remove Empty Lines
Delete every blank line, including lines that only contain spaces or tabs.
When to use it
Typical uses: Compacting lists copied from web pages or documents; Preparing lines for import into a spreadsheet; Cleaning log files and exported data.
In a pipeline
Text InputRemove Empty LinesText Output
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Text column | select | — | Text |
| 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
Remove Empty Lines: an example
| Text |
|---|
| First item Second item Third item |
| Text |
|---|
| First item Second item Third item |
Worth knowing
- Will it change the lines that contain text? No. Lines with content are left exactly as they are, including their leading spaces.
- Can I keep a single blank line between paragraphs? This tool removes all blank lines. To join wrapped lines while keeping paragraphs, use Remove Line Breaks.
- Does it work with Windows line endings? Yes. Both CRLF and LF line endings are handled.
- 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.