I’ve been working on this for ~3 hours without much progress.
I want to extract a list of numbers, and determine the maximum in the list.
Extracting, from the webpage, will keep the numbers as strings, and the max found will be ‘9’, and not ‘64’.
I can ‘for each’ and convert each row and write it out as an int, and write line it, but I actually don’t know if I can find the max from that list (i.e. and if the string > Int actually works)
I tried playing around with a lot of different conversion types, etc, but I always seem to get “cannot be converted” errors and the like.
My file is a bit of a mess, so ignore the areas that simply don’t work, I have commented them out anyway.
Attached is the file.
How is the best, most logical approach to this?
I did try and use BalaReva.DataTable.Activities - convert column data type, but it only seemed to have outputs.
Please assist, I’m going bonkers.
edit: additionally, I would get the error around "Strict Only is On, cannot do " I Am not sure if that is inhibiting me? I notice that it only seems to appear in this “test bed” file.
WebExtractTestBed.xaml (20.4 KB)