sorting sieve export

[pepi37]

I try for hours and try countless options / combinations but never got 100% what I need ( and ask for help here)

Using sort command under win

So input file is (fake data)

100156363476569 | 555*2^721991+1
100210790671219 | 111*2^483289+1
10133084529481 | 333*2^546934+1
101755669569157 | 111*2^479221+1
102599598829447 | 222*2^66533+1
102765600059849 | 555*2^1040951+1

I would like to sort file by k then by exponent so results should be like this

101755669569157 | 111*2^479221+1
100210790671219 | 111*2^483289+1
102599598829447 | 222*2^66533+1
10133084529481 | 333*2^546934+1
100156363476569 | 555*2^721991+1
102765600059849 | 555*2^1040951+1

[kar_bon]

Try this:
- your factors file is "test.txt"
- create awk file "listsort.awk" with code

{
  gsub(/*2\^/," ",$3)
  gsub(/+1/,"",$3)
  gsub(/-1/,"",$3)
  printf "%20s | %9s %15s\n",$1,substr($3,1,index($3," ")-1),substr($3,index($3," ")+1) >>"test.res"
}

- create batch "listsort.bat" with

gawk -f listsort.awk test.txt
sort /+23 test.res >test.srt
del test.res >nul

Your example result file "test.srt" looks like

     101755669569157 |       111          479221
     100210790671219 |       111          483289
     102599598829447 |       222           66533
      10133084529481 |       333          546934
     100156363476569 |       555          721991
     102765600059849 |       555         1040951

Perhaps some changes needed if length of k- or n-values are longer than given in the printf-line.

[Xyzzy]

You don't want to hear this, but this is why we use Linux.

$ cat file
100156363476569 | 555*2^721991+1
100210790671219 | 111*2^483289+1
10133084529481 | 333*2^546934+1
101755669569157 | 111*2^479221+1
102599598829447 | 222*2^66533+1
102765600059849 | 555*2^1040951+1

$ cat file | sort -t "^" -k2,2n | sort -t "|" -k2,2n -s
101755669569157 | 111*2^479221+1
100210790671219 | 111*2^483289+1
102599598829447 | 222*2^66533+1
10133084529481 | 333*2^546934+1
100156363476569 | 555*2^721991+1
102765600059849 | 555*2^1040951+1

[a1call]

In windows, I would import the text file into excel as delimited text:

Excel >> Data >> From Text >> use appropriate delimited separator say "space" >> sort on the desired column, say the exponent >> Copy-All & Paste into a text file

If it was worth wasting time programming for, I would use javascript. Runs fine on windows.

Just my 2 cents.

[kruoli]

Pepi, would you be willingly to use WSL or MSYS under Windows? Then you can use the suggested Linux solutions.