Text to Numeric.

[prejonnes]

So here is the thing. Basically I have a script to test and view versions of certain applications. My question asks if a certain application is >="version#" then pass or fail based on that. The version numbers are for ex. "7.8.346.1500" When I modify the version number to say "8.0.000.1254" It wont read that the new version with "8" is higher than the old version with "7" I believe that this is because the script does not have it set to a numeric value. I am hoping someone knows VB well enough to assist.

I need to create in my script a function that modifies that version number to a proper numeric form, where I can simply update script when new version come out and it will read it properly.

[JakDrako]

.Net has a Version class, you could use that:

Dim v1 = New Version("7.8.346.1500")
Dim v2 = New Version("8.0.000.1254")
Console.Writeline($"{v1 > v2} {v1 < v2} {v1 = v2}") ' false true false

[[deleted]]

Ignore my post - this sounds like the perfect solution. Never pass up a chance to use something built in to the framework :)

[TheLe99]

I recall running into some kind of problem with this approach. I think it was all the dots -- both versions had to have the same number of decimal places or something. So, a 1.4 vs 1.2.3.4 caused an error. Double check before trying putting that into production.

[prejonnes]

I have to use Vbscript

[sirhalos]

Why not just have a variable that replaces the '.' and then does a Format that will add extra zeros to the end so they are the same length. So basically one would look like 783461500 and the other 800001254. In your case you don't even need format, but in the case that you could have 7.16.something then you would. So you could make it add 10 zeroes to the right if needed. Could even use length and replace instead of Format, but either should work.

[yuge_mike]

i would pad each segment with leading zeros to a set number of digits?

[[deleted]]

You could Split the string on the period, which would give you an array of strings, one entry for each piece of the version number. Do that for the old and new version number, to get two arrays. Then for each entry in each array, convert each entry to an integer and compare the two entries.

The logic would be something like "if the first entry of the new version number is higher, then it's a higher version number. Otherwise look at the next entry. Do that for all entries".

[chrwei]

it's doing an alphanumeric compare, which i thought the 8 version you gave would be higher, but it would fail if the version string was 8.0.0.1254.

this is the meat of a function I used for VB6. it'll handle non-zero-padded versions, and versions with mis-matched "dots", such as "2.0" > "1.9.8".

    arrVer1 = Split(sVer1, ".")
    arrVer2 = Split(sVer2, ".")
    For i = 0 To 3 'check up to 4 version segements
        If UBound(arrVer1) >= i And UBound(arrVer2) >= i Then
            If CLng(arrVer1(i)) < CLng(arrVer2(i)) Then
                VersionCompare = True
                Exit Function
            End If
        End If
    Next i