Software versioning format

[nickhills]

hello guys,

i am trying to build a view of our software versions that we have deployed across our customer base.
our software versioning follows the version, major, minor format, i.e.
2.0.5

i am trying to apply a range map to a single button on the view, but not only does range map not support decimal values, but these values are not 'valid' decimal numbers since they have two decimal points.

does anyone know of a method to convert 2.0.5 to a number value we can run a calculation against.

logically something like this could work.

eval part1=left(version,3) - [returns 2.0]

part2 = tonumber(part1) * 100 - [returns 200]

part3 = right(version,1) - [returns 5]

part4 = part2 + tonumber(part3) - [returns 205]

this seems like an overly complex method, does anyone have any suggestions on a cleaner way of doing this?
is this even possible?

[_d_ · Accepted solution]

See if this helps:

<my search> | rex field=version mode=sed "s/\.//g"

This will remove all dots from the field called version and convert it to a number.

Hope this helps.

> please upvote and accept answer if you find it useful - thanks!

[aferone]

This drove me nuts for weeks until I found your solution.  Thank you very much!

[nickhills]

perfect.

i knew there would be a simple answer, i spent so much time trying to convert it to a numeric value, i didn't even think of regex.