Simple online tools for developers, networking, text and conversions.
Text Tools
Swap Arbitrary Delimited Columns Guide
Learn when to use Swap Arbitrary Delimited Columns, how to use it correctly, and how to avoid common mistakes.
What this guide covers
Use this tool to swap two selected columns in arbitrary delimited text. It is useful for pipe-separated, semicolon-separated, colon-separated, and other custom-delimited formats when column order needs to be fixed quickly.
This guide explains when to use Swap Arbitrary Delimited Columns, how to get a cleaner result,
and which mistakes to avoid before moving on to related tools or the main tool page.
Why use Swap Arbitrary Delimited Columns
Swap two fields in custom-delimited text quickly
Work with non-CSV and non-TSV separators
Fix column order without editing every row manually
Support both header names and 1-based indexes
Work directly in the browser
How to use Swap Arbitrary Delimited Columns
Put the delimiter on line one
Put the first column selector on line two
Put the second column selector on line three
Leave a blank line
Paste the delimited text below and run the tool
Best use cases
Fixing column order in pipe-separated exports
Reordering semicolon-separated data
Matching custom-delimited import templates
Cleaning flat text exports before sharing
Swapping fields without changing the values
Common mistakes
Using a column that does not exist
Fix: Check the header row or use a valid 1-based column number.
Using more than one character as the delimiter
Fix: Use a single-character delimiter such as ; | : or ,.
Selecting the same column twice
Fix: Use two different selectors.
Use the tool
Ready to run Swap Arbitrary Delimited Columns? Open the main tool page to enter your input,
generate the result, and copy or download the output.