Extract email from pipe-separated text
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.
Text Tools
Review practical Extract Arbitrary Delimited Column examples so you can understand expected input, output, and common patterns faster.
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.
Example pages are especially useful for text tools because they show what good input looks like, what kind of output to expect, and how the tool behaves in common scenarios.
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.
After reviewing these examples, run the live tool with your own input. If your task involves a follow-up step, the related page can help you move to the next tool in the workflow.
Open the main Extract Arbitrary Delimited Column page and test your own real input.