You noted: You must have missed my long-winded yet sparsely detailed explanation about how I pointed your script to a different folder, which contains real life files of all shapes, sizes and origin dates. Like this: I did see that, but had no access to your actual files. So I used my Testx,txt file...

I just saved POP3 emails from Thunderbird Email client. I selected them, did Save As to C:\Temp folder. They all saved with a format of Subject - Sender - Sent Date/Time.eml My file example: Article V Process - Sendername (emailaddress@gmail.com) - 2021-03-06 1131.eml This means we do not need to us...

Can you also let me know how you are saving the email files. If using Macro Scheduler code, please provide that. You said you are using POP3 connection, using which email client? After connected, how do you select the files and save them to disk. In a group, one at a time? I am sure the problem is i...

I'm happy you are content, but this is not over for me. This has become a personal issue now. We are running the same scripts, yours and mine and getting different results. The difference in our testing is the actual files we are trying to sort. I need the same real files to test. Can you send me fo...

AHA! I think I see a possible bit of confusion. You are thinking the Sorts, don't change, and I can now see what could be the issue. We could both be correct. I noticed that al your files show the same date and time. But my files (that I say work) all have different times. Did you make a Test file n...

So, what is the problem? You wrote: I do the GFL and the files are sorted descending. I set the variable to 4 and the files are still sorted descending. Is the problem that 3 is not in descending order, because they are not. Is the problem that 4 is in descending order, because they are, as they sho...

OK, I have run your code and still cannot duplicate your problem. Here is my version of your code. I added a vComma variable for your Separate command. The actual file uses commas for delimiter, you were using a semi-colon. I already had Temp1.txt that I had used in my test, but renamed them to MSG1...

Don't get rid of me that easy. Of course I believe you. But have been unable to duplicate your problem. Now that I see the code you are using, I think I have a much better of what you are doing. No time right now, but I have a few ideas, will try to test them out later tonight. One thing I will be d...

Ssorry about the 3/4 mixup, my mistake. I don't see a problem in GFL. Here is my test list: https://i.postimg.cc/VvgDGsMm/Tempx-Txt-Image.png And this code works for me: Let>GFL_SORTTYPE= GetFileList>c:\temp\temp*.txt,files MessageModal>files Let>GFL_SORTTYPE=0 GetFileList>c:\temp\temp*.txt,files Me...

Just curious about the sorting "field" you are looking at. Using "4" sorts by name, ascending. That is the File Name. Are you trying to sort by the Sender Name, or the Recipient Name? That would not be the Name used by the "4". If that is what you want sorted, we may be able to help you. And how are...

I did have a typo, but have modified the code in my reply above. From: Let>Pattern=[A-H][0-9][A-H][0-9][RKBQ]* To: Let>Pattern=[A-H][0-9][A-H][0-9]][RKBQ]? The last character of the RegEx should have been a "?" instead of "*". The * would have captured multiple instances of the last character. The ?...

You noted: //Macro Scheduler Normal Regex, does not seem to handle groups,MUST use Easy Pattern I don't use Easy Pattern, but I think you are wrong about groups in normal RegEx. If I understand your question, the fourth element of the RegEx expression, "Match Array", contains the groups. But instead...

I found your description a bit confusing, but I think understand it. I came up with some code that should look something like this: Let>VAREXPLICIT=0 Let>Pattern=[A-H][0-9][A-H][0-9][RKBQ]? Let>Source=A4C2L57LN8KG7D6B76GF RegEx>Pattern,Source,0,Match,Count,0,, MessageModal>Found %Count% matches%CRLF...

How about sending spreadsheet contents to a text file? I recently had to create a file with the contents of two columns from a spreadsheet. When I could not find an XL function to do that, I ended up doing it the hard way, but it made me think how convenient a function would be. Here is my code: XLS...

I have been getting a random error with the XSheetToArray command. XLSheetToArray>%vFileName%,Sheet2,vResults I get the error, sometimes, when running real time. If I single step through the script, I will get an error message: "A lock violation has occurred." I can still continue to single step thr...