Simple online tools for developers, networking, text and conversions.
Text Tools
Replace Arbitrary Delimited Column Guide
Learn when to use Replace Arbitrary Delimited Column, how to use it correctly, and how to avoid common mistakes.
What this guide covers
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.
This guide explains when to use Replace Arbitrary Delimited Column, how to get a cleaner result,
and which mistakes to avoid before moving on to related tools or the main tool page.
Why use Replace Arbitrary Delimited Column
Replace one field in custom-delimited text quickly
Work with non-CSV and non-TSV separators
Swap a header and values at the same time
Keep the rest of the structure intact
Work directly in the browser
How to use Replace Arbitrary Delimited Column
Put the delimiter on line one
Put the column name or 1-based column number on line two
Put the new header on line three
Put one replacement value per data row after that
Leave a blank line, paste the data, and run the tool
Best use cases
Replacing fields in pipe-separated exports
Updating one column in semicolon-separated data
Fixing bad custom-delimited flat text
Rebuilding one field without changing other columns
Preparing custom-delimited files for import or sharing
Common mistakes
Using more than one character as the delimiter
Fix: Use a single-character delimiter such as ; | : or ,.
The replacement values count does not match the row count
Fix: Provide one replacement value for each data row.
Forgetting the blank line before the data body
Fix: Put delimiter, selector, new header, and values first, then a blank line, then the data.
Use the tool
Ready to run Replace Arbitrary Delimited Column? Open the main tool page to enter your input,
generate the result, and copy or download the output.