Swap Text Columns

Choose a literal Delimiter and the first and second column numbers. On rows that contain both fields, their values exchange places and the row is joined with the same delimiter. Rows missing either requested column are left unchanged.

Column separator: initially ",". First column: initially 1. Accepted range: 1 to 10000. Second column: initially 2. Accepted range: 1 to 10000.

This example was checked with the current tool. The options shown apply only to this example; your editor keeps the settings you select.

Input

Ada,London,42
Lin,Paris,37

Result

London,Ada,42
Paris,Lin,37

Column separator: initially ",".; First column: initially 1. Accepted range: 1 to 10000.; Second column: initially 2. Accepted range: 1 to 10000.

The entry screen accepts one UTF-8 TXT, CSV, JSON, XML, HTML or HTM file and opens the editor. Imports are text content, not a PDF or Word conversion. Review the source and choose Swap Text Columns when ready. Editing or importing alone does not apply the transformation.

Result overview displays the table after the swap, with Rows, Columns and Rows with missing columns. Check the missing-column count: a row without either requested field stays unchanged. Select TXT for the editable text or CSV for the full table, then use the download icon. Editing the result hides the table and disables CSV until you rerun the tool; TXT and copy still use your edits. Continue to offers compatible next tools for the current text and their limits. Review the transferred text before running the next operation.