Numeric Sort doesn't work together with Use Locale

CyberMew · Aug 16, 2006#12006-08-16T15:07+00:00

I have some data, and either the sort doesn't have this function, or I don't know how to use it.

The data (fake) is something like this:

Code: Select all

repeat123 adrehadrhfe
repeat3465 gtgt343rrt
repeat239 ratrrtrtr4r
repeat391 w39dfd

Upon sorting, the result is as follows:

Code: Select all

repeat123 adrehadrhfe
repeat239 ratrrtrtr4r
repeat3465 gtgt343rrt
repeat391 w39dfd

This is what I want:

Code: Select all

repeat123 adrehadrhfe
repeat239 ratrrtrtr4r
repeat391 w39dfd
repeat3465 gtgt343rrt

I am pretty sure the program sorts them column by column, instead as a whole (e.g. repeat391).

The options has numeric sort selected.

Anyone help?

Bego · Aug 16, 2006#22006-08-16T16:06+00:00

Hi,

I think you need at least one space before your numbers.
If you switch to column mode and insert a blank after the repeat, it works fine. Afterwards, you can repeat this space easily again.

rds Bego

CyberMew · Aug 16, 2006#32006-08-16T16:21+00:00

Hi, thank you for replying.

I don't understand how to configure the column thing. It's complicated

And without the 'column' thing switched on, it works BUT I don't have time to type (and delete) spaces for thousands of lines (around 2500).

Mofi · Aug 16, 2006#42006-08-16T18:03+00:00

Click on Column - Column Mode or press Alt+C to enable the column mode.

Set the cursor after the t in repeat|123 in the first line.

Click on Column - Insert/Fill Columns, enter 1 space in the dialog and press OK.

Press again Alt+C to turn off the column mode and sort your file.

The inserted column can then be removed with Alt+C followed by Column - Delete Columns with cursor set before in the right column.

However, there is no need to insert a column here. Specify only following Advanced Sort/Options:

Start Column for Key 1: 7
End Column for Key 1: -1
All other start/end columns are set to 0.

Bego · Aug 16, 2006#52006-08-16T19:17+00:00

Column mode rules !!!
Personally, I go to the place at the first line where I want to start my "multiple line insert" and press ALT+C.
Then I press SHIFT and scroll down with the cursor (also SHIFT+PageDown is possible) as far as my block insert needs to be.
Then I just type what has to be inserted (here: a blank).
The input is placed in EACH line

rds Bego

CyberMew · Aug 16, 2006#62006-08-16T19:27+00:00

Thanks for the replies guy, but using both methods always keep repeat 391 at the end of the line.

Here are my settings:

and

Any idea what I am doing wrong?

Mofi · Aug 16, 2006#72006-08-16T20:04+00:00

Uncheck Use Locale and the numeric sort will work. Looks like a numeric sort with Use Locale is not possible.

Update: Starting with UE v14.20 and UES v6.70 enabling option Numeric sort disables automatically Use locale (slower) and Alternate sort not using virtual memory.

CyberMew · Aug 17, 2006#82006-08-17T08:36+00:00

Yea, it seems to work as intended. Thanks for both of your great help. Hopefully this thread will help some other people.

Search terms: sort, arrange, sorting, arranging