Text Tools
Extract one column from custom-delimited text by delimiter and column selector.
Use this tool to extract one selected column from arbitrary delimited text. It is useful when the data uses a custom separator such as semicolon, pipe, colon, or another single-character delimiter instead of CSV or TSV.
Use this tool to extract one selected column from arbitrary delimited text. It is useful when the data uses a custom separator such as semicolon, pipe, colon, or another single-character delimiter instead of CSV or TSV.
Use extract arbitrary delimited column when you need a fast browser-based result without extra setup. It works well for quick checks, one-off tasks, and routine formatting or calculation work.
Read step-by-step usage guidance, best practices, and common mistakes.
See common questions and answers about input, output, and tool usage.
Review practical input and output examples before running the tool.
Find similar and supporting tools for adjacent actions and follow-up tasks.
Input
| email name|email|role John|john@example.com|admin Jane|jane@example.com|user
Output
john@example.com jane@example.com
Useful when the source uses a pipe instead of CSV or TSV.
Input
; 2 name;email;role John;john@example.com;admin Jane;jane@example.com;user
Output
john@example.com jane@example.com
Supports 1-based column index selection.
Fix: Use a single-character delimiter such as ; | : or ,.
Fix: Check the header row and use the exact header text.
Fix: Put delimiter and selector first, then a blank line, then the data.
It extracts one selected column from flat text that uses a custom single-character delimiter.
Yes. Put the exact header name on the second line.
Yes. Use a 1-based column number on the second line.
Any single character such as ; | : or ,.
No. It returns the values below the header row.