Vincor

@gahhon Give also an example of Excel data - is it named fields, columns, etc, or how do you find your data in your spreadsheet? What kind of report do you need? Is it a single-page, lots of numbers kind of thing, or a many-pages bla-bla report? Does the output of the script need to be a PDF, or could it be e.g. Word, which you then "print" to a PDF?

How about StringSplit? https://www.autoitscript.com/autoit3/docs/functions/StringSplit.htm

And now, just for the fun of it, a solution using Regular Expressions: #include <StringConstants.au3> #include <Array.au3> Local $korobIdArray = StringRegExp(FileRead("file.tsv"),"(?m)^[^\t]\t(.*)$",$STR_REGEXPARRAYGLOBALMATCH) Local $uniqueIdArray = _ArrayUnique($korobIdArray, 0, 0, 0, 0)

Sounds like you had a sweat the other day... Reading the issue, it reminded me of another backup tool I used where you can use the drive's serial number instead of drive letter, exactly to avoid this issue with volumes changing letters. There is always room for yet another paranoid check...

Have you checked whether your SciTE or maybe even just its configuration files are write-protected? Check the read-only flag, the location of those files, and the rights of your windows user.

Ever wanted to keep a copy of a video message you got (or sent) through Skype? It is actually not so hard to get it manually, but here is a script that does it automatically. Before you try it, please note: the script has been tested on Skype v.7.x, running on Windows 7, but can be easily modified to work with Skype versions for Windows 8.x (or so I read). I have no Windows 8.x machine, and do not intend to change the script to support it until further notice. the URLs found in the Skype database are dynamic, and get invalidated after a while (within the hour in my experience). To get valid URLs in the database, open Skype and play the video messages you want to download. Once it starts playing within Skype, the link should be valid again. Try running the script after that. if the script takes a while to start, it could be because it didn't find sqlite3.dll, and will download it. If you want it to start without delay, put a copy of sqlite3.dll where the script can find it, e.g. in the same folder as the script. if you have more than one Skype user saved under your profile folder (@UserProfileDir & "AppDataRoamingSkype"), the script will go through all of them. Once again, only valid links will be downloaded. DownloadSkypeVideoMessages.au3

Very interesting idea, will definitely test it! Thanks

Tried briefly on W7 x64 - no flickering with $WS_EX_COMPOSITED, some flickering when removing it. Wow

Can be very useful here too. Once in a while I try to automate something with print queues and ports. I will have it a go in a few days. Thanks jguinch

You should take a look at this project: More or less the same you are doing: download files, progress bar, regexes... Only the focus is on downloading free software, but you get the idea.

That is right. In that regex, the .*? means the following: - The dot will match any character - The * makes the dot match 0 or more times. To understand this better, please try with + instead of *. The plus means "match 1 or more times the previous". You would be just as well serve in your regex with the plus, if you assume there will always be a movie name between "movie/" and "/" - The question mark tell the regex to match the smallest match instead of the largest. Not sure why you put that there, I just didn't remove it. I would write it differently: $string = StringRegExp($source, 'movie/([^/]+)/', 3) That means, find the string "movie/", then capture everything after that that is NOT a slash (/), until you find a slash. Then stop.

See this post: Then add a -s to your psexec calls, when using your admin credentials. That will enable running as system. (http://ss64.com/nt/psexec.html) Plus, your code needs some polishing. Your loop doesn't seem right. That $eachline is not going anywhere...

Hmmm, I see. Next questions would be: - Are these computers (yours, remote?) in a domain? - Are you admin in that domain? - Are you running your script locally or at the remote computer? Maybe you'd solve this with e.g. PSTools by SysInternals?

Googling for "autoit require elevation" gives this as first link: http://www.autoitscript.com/autoit3/docs/intro/autoit_on_vista.htm Isn't it what you need?

The parenthesis are the capturing element in your regex. Not all that matches must be captured. Try this: $string = StringRegExp($source, 'movie/(.*?/)', 3) That is shown in the very first example in the documentation of the function you are using: http://www.autoitscript.com/autoit3/docs/functions/StringRegExp.htm Now, how would you remove the dash only by changing the regular expression above?