Numeric Sort doesn't work together with Use Locale

Numeric Sort doesn't work together with Use Locale

4
NewbieNewbie
4

    Aug 16, 2006#1

    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?

    344
    MasterMaster
    344

      Aug 16, 2006#2

      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
      Normally using all newest english version incl. each hotfix. Win 10 64 bit

      4
      NewbieNewbie
      4

        Aug 16, 2006#3

        Hi, thank you for replying.

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

        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).

        6,683583
        Grand MasterGrand Master
        6,683583

          Aug 16, 2006#4

          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.
          Best regards from an UC/UE/UES for Windows user from Austria

          344
          MasterMaster
          344

            Aug 16, 2006#5

            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
            Normally using all newest english version incl. each hotfix. Win 10 64 bit

            4
            NewbieNewbie
            4

              Aug 16, 2006#6

              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?

              6,683583
              Grand MasterGrand Master
              6,683583

                Aug 16, 2006#7

                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.
                Best regards from an UC/UE/UES for Windows user from Austria

                4
                NewbieNewbie
                4

                  Aug 17, 2006#8

                  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