topic Software versioning format in Dashboards & Visualizations

Software versioning format

nickhills — Tue, 22 Nov 2011 17:25:55 GMT

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?

Re: Software versioning format

_d_ — Tue, 22 Nov 2011 17:51:21 GMT

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!

Re: Software versioning format

nickhills — Tue, 22 Nov 2011 21:31:14 GMT

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.

Re: Software versioning format

aferone — Thu, 11 Feb 2021 23:56:34 GMT

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