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?