Delimited Text Extractor
FV-39Pull chosen columns out of comma, tab, semicolon, pipe, colon or space separated text, or delete those columns and keep the rest. Put the column numbers on the first line.
Runs in your browser. Nothing is uploaded.
First line: -- column: 2 (or 1,3 or 2-4). Then the delimited rows
Result
How to use it
- Write the first line as -- column: 2, or -- column: 1,3 for several columns, or -- column: 2-4 for a range. Columns start at 1.
- Paste the delimited rows under it.
- Pick the delimiter from the menu, or add a second line such as -- delimiter: ; to set it in the text.
- Press Extract columns to keep only those columns, or Remove columns to drop them and keep the others.
Extract keeps, remove drops
Extract columns writes only the listed columns, in the order you list them, so -- column: 3,1 swaps them. Remove columns writes every column that is not listed, in the original order. If a row is shorter than the column you ask for, extract pads it with an empty field, and the tool stops with an error only when no row at all reaches that column. Remove refuses to delete every column, because nothing would be left.
Quotes and delimiters inside fields
A field wrapped in double quotes can contain the delimiter, a line break or a doubled quote written as two double quotes. The tool reads those fields as one value and writes quotes back only where the value needs them. Quotes are recognised at the start of a field only. With the space delimiter, tick Treat repeated spaces as one when the text is aligned with several spaces. Tick Skip the first data row to leave a header out of the result.
What it does not do
This is plain text parsing. It does not guess the delimiter, does not infer data types, and does not read column names, so refer to columns by number. It works on text you paste, so for a spreadsheet file copy the cells first. The result is a text block with the same delimiter as the input, which you can paste back into a spreadsheet or save as a text file.
Error messages and what to do
| Message | What it means | Fix |
|---|---|---|
Start the first line with -- column: followed by a column number, a list such as 1,3, or a range such as 2-4. | The first line is not a column directive. | Add a first line such as -- column: 2, then put the rows below it. |
No rows found after the first line. | There is no text under the directive, or the only row was skipped as a header. | Paste the rows under the first line, or untick Skip the first data row. |
Every column would be removed. Leave at least one column. | The columns you listed cover every column in the data. | List fewer columns, or use Extract columns instead. |
Questions people ask
How do I extract a column from comma separated text?
Write -- column: 2 on the first line, paste the rows below it, choose Comma as the delimiter and press Extract columns. For several columns write 1,3, and for a range write 2-4.
How do I delete a column from a CSV file?
Paste the rows, write -- column: followed by the number of the column to delete on the first line, and press Remove columns. Every other column is kept in its original order. Copy the result back into a file.
Can it handle fields that contain commas?
Yes, when the field is wrapped in double quotes, as in "Smith, Ada". The quoted field is read as one value, and the output adds quotes again only where the value contains the delimiter, a quote or a line break.
What delimiters are supported?
Comma, tab, semicolon, pipe, colon and space from the menu. For any other single character, add a line such as -- delimiter: ~ under the column line, which overrides the menu.
Does the first row count as a column header?
Not unless you say so. Every row is data by default, so a header row is extracted like any other. Tick Skip the first data row to leave it out of the result.
Are columns numbered from 0 or 1?
From 1. Column 1 is the first field on each line. A range such as 2-4 includes both ends, and a range written backwards, such as 4-2, is rejected with an error.
About this tool
The first line is a directive, -- column: followed by a 1-based column number, a comma list such as 1,3, or a range such as 2-4. You can add a second directive line, -- delimiter: followed by one character or one of the words comma, tab, semicolon, pipe, space, colon, which overrides the menu. Extract keeps only the listed columns in the order you wrote them; Remove keeps every other column. Fields wrapped in double quotes may hold the delimiter, line breaks and doubled quotes, and quotes are re-added on output only where the value needs them. Quotes are recognised only at the start of a field. Short rows are padded with empty fields when extracting. This is plain text parsing, not a spreadsheet: it does not detect the delimiter for you and does not infer types. It runs in your browser and nothing is uploaded.