#10407

Stefan
Participant

You can sort by column in EmEditor
while you are in “Separated Values” mode.

1.)
Therefor you have to delimiter your columns first by either
* one tab (t) => TSV mode
* one coma (,) => CSV mode
* one own delimiter => DSV mode ( e.g. one “:” or “|” or “;” or one space ” ” or…)

Hint: For your examples
RegEx Search for three-or-more spaces
and replace by an coma:
Find: s{3,}
Replace: ,
[X] Use Regular Expressions
Now you have CSV.

2.)
Next switch to delimiter mode via
menu “Edit > Separated Values/Sort > selecting-your-mode”

For your case use CSV if you have followed the s&r tip.

Hint: you must seen some thin vertical lines.

3.)
Then click into an column and use an Sort mode.

Explanation:
CSV means “Coma Separate Value” and you
must have an coma between your columns.
There must be NO coma inside the column itself!

TSV means “Tabulator Separated Value”
and the same is valid as said for CSV.

DSV means “Defined(by user) Separated Value”
and you have to set the delimiter yourself
e.g to ‘;’ or ‘|’ or something like that.
To setup the DSV delimiter go to menu
“Tools > Properties for X”
and at the [File] tab
set the “Delimiter [; ]”

Since spaces can sophisticate the sorting
be sure to have no, or at least the same
amount of spaces around your delimiter.
(Your example lines have uneven amount
of spaces between the columns)

Please note that you can also right click
the ruler to get the “Separated Value” menu.

HTH?

For more read the help or visit
http://www.emeditor.com/modules/feature1/rewrite/tc_35.html#csv
http://www.emeditor.com/modules/tutorials4/index.php?id=35