Setting Data Type to Versions: Sorting and Filtering Insights

·

A way to set a Data Type to Versions. Very different than numbers when it comes to sorting and filtering 🙂

· Sorted by Oldest

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 😞
Frantisek K.
·
·
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
Andrew S.
·
·
Yeah, I was going to say if you put a two digit (01, o02, etc) then it works. I do it with everything (files on my computer, etc) bc strings don’t sort numbers right

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 😞
Frantisek K.
·
·
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
Andrew S.
·
·
Yeah, I was going to say if you put a two digit (01, o02, etc) then it works. I do it with everything (files on my computer, etc) bc strings don’t sort numbers right