Search found 2401 matches
- Sat Mar 06, 2021 9:13 pm
- Forum: Technical / Scripting
- Topic: GFL_SORTTYPE
- Replies: 35
- Views: 23918
Re: GFL_SORTTYPE
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...
- Sat Mar 06, 2021 5:51 pm
- Forum: Technical / Scripting
- Topic: GFL_SORTTYPE
- Replies: 35
- Views: 23918
Re: GFL_SORTTYPE
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...
- Sat Mar 06, 2021 4:23 pm
- Forum: Technical / Scripting
- Topic: GFL_SORTTYPE
- Replies: 35
- Views: 23918
Re: GFL_SORTTYPE
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...
- Sat Mar 06, 2021 3:47 pm
- Forum: Technical / Scripting
- Topic: GFL_SORTTYPE
- Replies: 35
- Views: 23918
Re: GFL_SORTTYPE
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...
- Sat Mar 06, 2021 5:34 am
- Forum: Technical / Scripting
- Topic: GFL_SORTTYPE
- Replies: 35
- Views: 23918
Re: GFL_SORTTYPE
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...
- Sat Mar 06, 2021 1:30 am
- Forum: Technical / Scripting
- Topic: GFL_SORTTYPE
- Replies: 35
- Views: 23918
Re: GFL_SORTTYPE
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...
- Sat Mar 06, 2021 12:37 am
- Forum: Technical / Scripting
- Topic: GFL_SORTTYPE
- Replies: 35
- Views: 23918
Re: GFL_SORTTYPE
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...
- Fri Mar 05, 2021 11:07 pm
- Forum: Technical / Scripting
- Topic: GFL_SORTTYPE
- Replies: 35
- Views: 23918
Re: GFL_SORTTYPE
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...
- Fri Mar 05, 2021 7:53 pm
- Forum: Technical / Scripting
- Topic: GFL_SORTTYPE
- Replies: 35
- Views: 23918
Re: GFL_SORTTYPE
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...
- Fri Mar 05, 2021 5:52 pm
- Forum: Technical / Scripting
- Topic: GFL_SORTTYPE
- Replies: 35
- Views: 23918
Re: GFL_SORTTYPE
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...
- Fri Mar 05, 2021 4:29 pm
- Forum: Technical / Scripting
- Topic: EasyPatterns Not so easy
- Replies: 7
- Views: 3340
Re: EasyPatterns Not so easy
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 ?...
- Fri Mar 05, 2021 3:13 am
- Forum: Technical / Scripting
- Topic: Easy Pattern syntax for Groups
- Replies: 2
- Views: 1885
Re: Easy Pattern syntax for Groups
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...
- Fri Mar 05, 2021 2:50 am
- Forum: Technical / Scripting
- Topic: EasyPatterns Not so easy
- Replies: 7
- Views: 3340
Re: EasyPatterns Not so easy
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...
- Wed Oct 10, 2012 1:47 am
- Forum: Enhancement Suggestions
- Topic: XLSheetToFile
- Replies: 0
- Views: 8218
XLSheetToFile
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...
- Tue Oct 09, 2012 9:22 pm
- Forum: Technical / Scripting
- Topic: XLSheet to Array trouble
- Replies: 1
- Views: 2745
XLSheet to Array trouble
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...