Frantisek K.

Commented on Setting Data Type to Versions: Sorting and Filteri...·Posted inProduct Ideas

btw I came up with this workaround at least to make from the above via calculated custom property

LET(ver, @"""{ }"""@,
  a, REGEX_REPLACE(ver, "(^|\\.)(\\d)(\\.|$)", "${1}0${2}${3}"),
  b, REGEX_REPLACE(a, "(^|\\.)(\\d)(\\.|$)", "${1}0${2}${3}"),
  c, REGEX_REPLACE(b, "0(.*)", "$1"),
  c
)

this changes the

1.7.9 to 1.07.09
1.7.0 to 1.07.00
1.7.15 to 1.07.15

etc .. feel free to experiment a bit with the regexp.s to get your desired output

Commented on Setting Data Type to Versions: Sorting and Filteri...·Posted inProduct Ideas

Frantisek K.

any update on this? it's a bit annoying that versions are not sorted properly ... 1.7.9 1.7.8 1.7.7 1.7.6 1.7.5 1.7.4 1.7.3 1.7.2 1.7.13 1.7.12 1.7.11 1.7.10 1.7.1 is not the right way to sort this 😞