AutoHotkey Community

newpie

I managed to get it working by changing the placement of the date to 1st column, but I am still curious on how to sort another column if not in first. Thanks var = ( 2016/05/30,foo,bar,foo,bar,foo,bar 2016/05/30,foo,bar,foo,bar,foo,bar 2016/05/27,foo,bar,foo,bar,foo,bar 2016/05/30,foo,bar,foo,bar,fo...

newpie

Hello, is there a way to use the sort command to sort this format of date like below, doesn't matter if asc or dsc, just as long the dates are grouped. var = ( foo,bar,foo,bar,foo,2016/05/30,bar foo,bar,foo,bar,foo,2016/05/30,bar foo,bar,foo,bar,foo,2016/05/27,bar foo,bar,foo,bar,foo,2016/05/30,bar ...

newpie

Hey sinkfaze, I have not tried that, how do you get the fileopen into a var with file object to be used for your script by chance (String := File.Read([Characters])? f2:: File := FileOpen("folder\test1.csv", "r") Sort, File, U Sort, File, F customNumDateSort3 Fileappend,%File%,folder\test2.csv retur...

newpie

Hey sinkfaze, turns out this is screwing me with the fileread as my file is greater than 1 mb. From Docs about fileread: When the goal is to load all or a large part of a file into memory, FileRead performs much better than using a file-reading loop. A file greater than 1 GB in size will cause Error...

newpie

Awesome, works like a charm. Thanks allot sinkfaze for replying to my post.

newpie

Ok, thanks for heads up. I just tried the new alter code. It gave me the following results, it looks like if the goal is to put the oldest time on the top then it is not working if I am reading the results correctly. The 18th should be below the 16th, right? 75924160,blah,blah,blah,2015/01/16 01:21:...

newpie

Thank you sinkfaze , I will analyze the DateParse function as well I did have a quick question, hopefully. How do I target columns if there is multiple timestamps in other columns. I did test the below and it came out fine. I was just wondering how the 4th column is targeted in the above code. Thank...

newpie

Hello, I am trying to figure out how to sort two columns sequentially, like you can do in excel, with a csv file. So the below would sort column 1 first, and then put the oldest time (column 5) at the top of the list. I will run a code to take out duplicates using the Sort, U command prior. Original...

newpie

Thank you for the super fast response. I will try this out.

newpie

Hello, I know how to delete duplicates with the following code: FileRead, OutputVar, %User%\File.csv Sort, OutputVar, u sleep, 300 FileAppend, %OutputVar%,%User%\File2.csv I am now trying to delete all entries but the first within duplicate Record numbers OR keep the record that has the youngest tim...

newpie

Update: Looks like that fixed it Lexikos (updating my compiler). Thanks

newpie

Thanks for replying quickly lexikos. I will check out the version and let you know and try some different compilers. For whatever reason I kept using the old compiler on my usb, I found the 1.1.22.02 one so I will try that as well.

newpie

Sorry for the late reply. I got help on this code from this link. It does work in regular script form, but doesn't in exe apparently when I try it at work. @Miguel7 = You are correct I use that code in a loop which pulls the file names for me. Here is the link I was referring too: http://www.autohot...

newpie

Hello, I am using version 1.1.22.02 and the new compiler (ahk2exe for autohotkey v1.1.13.01 --Script to EXE Converter). If the script is run "as is" it works fine, but when the script is compiled to an exe file it does not work and returns nothing. Any tips to get it working for the executable file?...

newpie

Thanks for your help and time with this one guys.

newpie

Hello, I been experimenting with regex and had a question related to variables. The below code works fine, if you replace the Haystack with the appropriate Message, MessageA = [7/4/2015 10:37:06 AM] Fred: Hello Friend MessageB = [7/4/2015 10:37:06 AM] Fred: Hello Bob MessageC = [7/27/2015 10:00:33 P...

newpie

Wow great, thanks kon. Appreciate it

newpie

Thanks allot kon, I am going to try to pick it apart so I can understand and learn.

newpie

Update: From my tests I discovered by accident that print.exe does in fact work fine if you send multiple jobs to the printer at the same time. It treats it like any other print job and processes it in order of receive. I appreciate your comments from the above. Thanks

newpie

Update- I tested run as admin on the system and the code works as well as "blockinput, on and off". The problem is even if I change the compatibility settings to "always run as admin" for other users it doesn't stick I am afraid as I tested it with an other user. So I know no way to make it stick pe...

Search found 37 matches

Re: Sort CSV Date Column

Sort CSV Date Column

Re: Multi Column Sort CSV

Re: Multi Column Sort CSV

Re: Multi Column Sort CSV

Re: Multi Column Sort CSV

Re: Multi Column Sort CSV

Multi Column Sort CSV

Re: Delete certain records of CSV File

Delete certain records of CSV File

Re: Array not working in compiled file

Re: Array not working in compiled file

Re: Array not working in compiled file

Array not working in compiled file

Re: NeedleRegEx Variable help

NeedleRegEx Variable help

Re: Word Retrieval ... Possible RegEx Solution?

Re: Word Retrieval ... Possible RegEx Solution?

Re: Network Knowledge Print.exe Question!

Re: Blockinput not activating- Network?