Text Tools
Replace one selected column in custom-delimited text with a new header and new values.
Use this tool to replace one selected column in arbitrary delimited text. It is useful for semicolon-separated, pipe-separated, and other custom flat formats when you need to rebuild one field without editing every row manually.
Use this tool to replace one selected column in arbitrary delimited text. It is useful for semicolon-separated, pipe-separated, and other custom flat formats when you need to rebuild one field without editing every row manually.
Use replace 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 username john jane name|email|role John|john@example.com|admin Jane|jane@example.com|user
Output
name|username|role John|john|admin Jane|jane|user
Useful when rebuilding one field in a custom-delimited export.
Input
; 2 status active pending id;title;role 1;Book;admin 2;Pen;user
Output
id;status;role 1;active;admin 2;pending;user
Supports both header-based and index-based selection.
Fix: Use a single-character delimiter such as ; | : or ,.
Fix: Provide one replacement value for each data row.
Fix: Put delimiter, selector, new header, and values first, then a blank line, then the data.
It replaces one selected column in custom-delimited text with a new header and new values.
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 only replaces the selected column.