Search found 37 matches

by newpie
03 Jun 2016, 16:04
Forum: Ask For Help
Topic: Sort CSV Date Column
Replies: 5
Views: 1869

Re: Sort CSV Date Column

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...
by newpie
03 Jun 2016, 15:52
Forum: Ask For Help
Topic: Sort CSV Date Column
Replies: 5
Views: 1869

Sort CSV Date Column

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 ...
by newpie
21 Jan 2016, 15:41
Forum: Ask For Help
Topic: Multi Column Sort CSV
Replies: 10
Views: 2764

Re: Multi Column Sort CSV

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...
by newpie
21 Jan 2016, 15:09
Forum: Ask For Help
Topic: Multi Column Sort CSV
Replies: 10
Views: 2764

Re: Multi Column Sort CSV

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...
by newpie
20 Jan 2016, 19:39
Forum: Ask For Help
Topic: Multi Column Sort CSV
Replies: 10
Views: 2764

Re: Multi Column Sort CSV

Awesome, works like a charm. Thanks allot sinkfaze for replying to my post.
by newpie
20 Jan 2016, 12:01
Forum: Ask For Help
Topic: Multi Column Sort CSV
Replies: 10
Views: 2764

Re: Multi Column Sort CSV

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:...
by newpie
20 Jan 2016, 11:38
Forum: Ask For Help
Topic: Multi Column Sort CSV
Replies: 10
Views: 2764

Re: Multi Column Sort CSV

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...
by newpie
20 Jan 2016, 10:11
Forum: Ask For Help
Topic: Multi Column Sort CSV
Replies: 10
Views: 2764

Multi Column Sort CSV

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...
by newpie
03 Jan 2016, 22:45
Forum: Ask For Help
Topic: Delete certain records of CSV File
Replies: 2
Views: 902

Re: Delete certain records of CSV File

Thank you for the super fast response. I will try this out.
by newpie
03 Jan 2016, 16:25
Forum: Ask For Help
Topic: Delete certain records of CSV File
Replies: 2
Views: 902

Delete certain records of CSV File

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...
by newpie
19 Aug 2015, 17:25
Forum: Ask For Help
Topic: Array not working in compiled file
Replies: 6
Views: 1971

Re: Array not working in compiled file

Update: Looks like that fixed it Lexikos (updating my compiler). Thanks
by newpie
18 Aug 2015, 20:57
Forum: Ask For Help
Topic: Array not working in compiled file
Replies: 6
Views: 1971

Re: Array not working in compiled file

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.
by newpie
18 Aug 2015, 20:26
Forum: Ask For Help
Topic: Array not working in compiled file
Replies: 6
Views: 1971

Re: Array not working in compiled file

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...
by newpie
16 Aug 2015, 09:55
Forum: Ask For Help
Topic: Array not working in compiled file
Replies: 6
Views: 1971

Array not working in compiled file

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?...
by newpie
28 Jul 2015, 17:52
Forum: Ask For Help
Topic: NeedleRegEx Variable help
Replies: 3
Views: 1337

Re: NeedleRegEx Variable help

Thanks for your help and time with this one guys.
by newpie
27 Jul 2015, 23:12
Forum: Ask For Help
Topic: NeedleRegEx Variable help
Replies: 3
Views: 1337

NeedleRegEx Variable help

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...
by newpie
14 Jul 2015, 19:23
Forum: Ask For Help
Topic: Word Retrieval ... Possible RegEx Solution?
Replies: 4
Views: 1245

Re: Word Retrieval ... Possible RegEx Solution?

Wow great, thanks kon. Appreciate it
by newpie
13 Jul 2015, 19:16
Forum: Ask For Help
Topic: Word Retrieval ... Possible RegEx Solution?
Replies: 4
Views: 1245

Re: Word Retrieval ... Possible RegEx Solution?

Thanks allot kon, I am going to try to pick it apart so I can understand and learn.
by newpie
12 Jul 2015, 22:43
Forum: Ask For Help
Topic: Network Knowledge Print.exe Question!
Replies: 11
Views: 2779

Re: Network Knowledge Print.exe Question!

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
by newpie
12 Jul 2015, 22:41
Forum: Ask For Help
Topic: Blockinput not activating- Network?
Replies: 6
Views: 1995

Re: Blockinput not activating- Network?

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...

Go to advanced search