No problem, I got a bit carried away and re-wrote most of the code using xpath to replace every one of the image recognition calls I had, which has made things much faster and reliable (especially with our range of monitors and resolutions) Very happy so far. For reference I found this page incredib...

I've resolved my issue. I had a read up on xpath, which seems like a nice powerful tool that should help with eliminating some of my image recognition elements I had to use, so that's great. To grab the data from my tables the following works fine: ChromeFindElements>session_id[2],xpath,//td[@class=...

Hi, I'm moving code over that used to pull data in via IE to use the new Chrome integration. The page I want to pull data from has all the values in a table like this: <tr> <th>Increment Id</th> <td class="increment_id">100134934</td> </tr> <tr> <th>Entity Id</th> <td class="entity_id">141553</td> <...

Ahh fantastic, that solves my issue. Although doesn't explain why the xls approach didn't work, as you can't have a schema with an xls (I don't think???) so it should have taken the fact I'd formatted the column to be text. But as you say if I go back to importing a CSV rather than an XLS I can use ...

Just done some more testing .... If I make a really basic spreadsheet like: Make Model Car1 Text Car1 1 Car1 1 Car1 Text Car1 Text Car1 1 Car1 Text Car1 1 Car1 Text Car2 Text Car2 Text Car2 Text IT seems that if there are 4 or more cells in the top 9 Model rows that are integer then it only returns ...

I've been successfully pulling in data and manipulating it for some time without issues, but I've just edited an old script to work with some new data and hit an odd problem. I was pulling in CSV data using DBquery, but suddenly I started to get very strange outputs from my script. Assuming I'd acci...

I've worked out what was happening, and learned something new in macro scheduler at the same time ;) I worked out how to set a numerical calculation as a string: let>test={"123-123"} makes test=123-123 rather than let>test=123-123 which is 0 however my actual issue was with DBQuery, the data was act...

Hi, I can't work out how to ensure that a variable isn't interpreted as an integer. I'm pulling in data from an excel spreadsheet with a car make and model in different cells then combining them. so for example I have a spreadsheet with: A1:Ford B1:Mondeo C1:2000-20005 I am then loading the spreadsh...

I've not really used SQL before, but I can't see it being too much of a challenge for such a simple search.
Thanks for the link, I'll have a look into it.

Hi, is there a quicker way of searching an array. I'm currently reading in a lookup file and then running line by line through a much larger text file and then acting on that line if it's found in the lookup file. The lookup file is 115 lines long, has a lookup and replacement value separated by a c...

Cheers, that looks perfect! I've not used lists before, as my list of replacements is getting a little unwieldy already can I throw it into a single (very long) line so I've not got 200+ rows of text, so rather than RepList: Á,A À,A Â,A Ă,A Ā,A Ã,A Å,A Ą,A I have RepList: Á,A~À,A~Â,A~Ă,A~Ā,A~Ã,A~Å,A...

I've got a script that logs into our shop system and claws out all the details needed for order shipment, it then formats that data in a suitable format for batch Fedex/DPD shipping. Everything was going well until I found the DPD and Fedex apps can't cope with special characters. So I need a way of...