Search code examples
csvtexteditemeditor

A question about column editing in Emeditor


I have 5 columns:

enter image description here

How can I get this result?

enter image description here

Thank you..


Solution

  • After you open the CSV file, click the Extract Columns button on the CSV/Sort toolbar. In the Extract Columns dialog box:

    1. Reverse the order of columns 2 - 5. To do this, you can drag and drop items in the list, or use the Up/Down buttons.

    EmEditor - Extract Columns dialog box

    1. Select the columns 2 - 4, and set the Combine with previous column and Use first non-empty value options.

    2. Click OK.