Text Tools

Replace Arbitrary Delimited Column Examples

Review practical Replace Arbitrary Delimited Column examples so you can understand expected input, output, and common patterns faster.

Why examples matter for Replace Arbitrary Delimited Column

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.

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.

Replace Arbitrary Delimited Column examples

Replace email with username in pipe-separated data

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.

Replace second field by number

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.

How to use these examples

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

Compare your own input with the Replace Arbitrary Delimited Column examples below before running the tool.
Keep the input format as close as possible to the example pattern when you test a new case.
If your output looks wrong, check spacing, separators, symbols, or the exact value type first.

Common mistakes in sample input

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.

Next steps

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.

Run the main tool

Open the main Replace Arbitrary Delimited Column page and test your own real input.

Open Replace Arbitrary Delimited Column