Issues with tricky click selector

Hi all,

I am having some trouble with an automation clicking the latest search results:

In short - I need the bot to click on the highest number on the end, so the vehicle name/make etc and then the latest date (in this case 2022.25). I had written the below code which I believed was working, however, it appears to not like decimal spaces and so thinks that the highest number is 2022 (top result).

I have a variable being made from these scraped search results which is then used as a selector to click the list:

VariableName = pDT.AsEnumerable.OrderByDescending(Function(x)Cint(If(Split(x(0).ToString).Last.Trim.IsNumeric,Split(x(0).ToString).Last.Trim,"0"))).First.Item(0).ToString

Can anyone please help me work out what is preventing this from accessing the .25? Please also be aware that the .25 could be any number, so .5, .75 etc and so it needs to be able to read the whole last number to determine this.

Thank you for your help.

Edit: I think it is because it is a Cint, but unsure how to convert it to a double?

CDbl worked instead of Cint

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.