ProgAndy

If you want / have to use Python for most of your code, and mouse clicks are not enough, then you could have a look at pywinauto or try to create a ctypes wrapper for AutoItX.dll.

The COM specification does not allow overloaded methods, so you cannot do that.

I know why my UDF does not work with your file. First, it creates an array which can hold all available fields as single records, afterwards it adds a column if required and does not reduce allocated space in the first dimension. This is done only at the very end.To fix that, you'll have to cut down the record count of the array when adding an additional column which forces some more error checking in return. Edit: improved wording. I have a fixed version and currently am running some tests with openURL routing data.

For SQLite you need to copy a DLL in the same folder as your script and use it with SQLite.au3, examples are in the helpfile.The current DLLs compiled for AutoIt can be found here: 32bit, 64bit

Why don't you import all data in an SQLite database? This should be faster than anythin you could write in AutoIt once you created the initial database file.

If you want to use the supplied filename, you'll have to do the download with WinHTTP I think. - open session - connect to server - request file - read headers - read data to file - close request, connection, and session

I think your best option on linux is python with dogtail or ldtp

Good question. I suggest you don't use MemoryDLLOpen/...Call/...Close anymore, but the MemLib-functions contained in this UDF. Something like this is better since we have DLLCallAddress: $hMod = MemLib_LoadLibrary(...) $pFunc = MemLib_GetProcAddress($hMod, "SomeFunc") $aRet = DLLCallAddress("int", $pFunc, "str", "param1", ...) MemLib_FreeLibrary($hMod)

0.0199695295556956 - ([[:xdigit:]]{32})h+*([^*?/|"<>[:cntrl:]]+) This pattern only accepts at least one space and one star as delimiter. Replace h+* with h*[ *|] for horizontal whitespace followed by space, star or pipe.

You could also use ([[:xdigit:]]{32}) I think. It might be slightly faster since it is a predefined character class.

If you cannot set up a database server, then sqlite would be a good choice I guess. MS Access files are not designed for concurrent write access. If you only read, then it should be acceptable, though. MySQL is one server based solution, MS SQL Express another. (WAMP contains Apache, MySQL and PHP)

If you need only MySQL that is overkill. If you are in a corporate network, there could already exist a MS SQL server, so you could try to use it or install your own MS SQL express server. When you are already using Access, the MS server is a better choice since it integrates seamlessly with it.

You have to count all characters for the minimum length. 4 digits + 1 decimal mark + 4 digits = 9 chars stringformat("%09.4f",round(timerdiff($time)/1000,4))

The boundary is not different from the standards, but the boundary set in the header must have 2 hyphens less at the beginning than used in the body. Fields are separated with newline, two hyphens, boundary, newline Here is a working example (if the api of the website wasn't changed)

Here is my take on the functions