Understanding Sort Sequence

[froggie]

I don't understand what the sort sequence is here - it look like it is extracting the numeric part of the field and sorting on that -
99B followed by 114. - is this correct? I can't find any description of it.

Capture. PNG

Capture.PNG (31 KiB) Viewed 997 times

Capture.PNG

[void]

Everything will do a natural sort.

A sequence of numbers is sorted by value.
1 < 2 < 10

[santilli]

I don't understand what the sort sequence is here - it look like it is extracting the numeric part of the field and sorting on that

Not quite.

a:=substr($name:,2,3)

sets the value of A to a substring of Name, following this structure:

,2

excludes the first character of the file name

,3

sets the max length of the string to 3 characters

sort:a

sort by the A column ascending

b:=hex(a:)

converts the value of A to a Hexadecimal value and makes it the value of B

A file named

!0hgvtx27uqukksr9uu2fy_source.mp4

will become

0hg

in the A column
A file named

0hgvtx27uqukksr9uu2fy_source.mp4

will become

hgv

in the A column

[froggie]

Yes, that is what my search does. It was the sort term I was asking about.