AutoHotkey Community

Chunjee

it's written in Node/Javascript.

I changed the date parsing and comparison so whatever I posted about that earlier is no longer valid.

Chunjee

{ "name": "cc-filecountbydate", "version": "0.1.0", "description": "file countingbydate", "main": "app.ahk", "scripts": { "newinstall": "yarn install --modules-folder ./lib" }, "repository": { "url": "https://www.autohotkey.com/boards/viewtopic.php?f=76&t=67965" }, "dependencies": { "sort-array.ahk...

Chunjee

That is fairly simple but you did not give an example of the formatting you are using for the date.

Regardless, I have a function to best guess the date.

Chunjee

Not enough detail for me, at least post a sample json file. It looks like you are doing a lot of unnecessary work to create new json files when you can just stringify ahk objects instead of all this: Js := SubStr(Js,2,StrLen(Js) - 2) Js := StrReplace(Js,"],[",",",,Limit:=-1) FileDelete,%Temp%\Js%uni...

Chunjee

I think you are trying to grab data off a website but none of the posts say so. Your video is unclear and also doesn't show any ahk code so we still don't know what you're working with.

Chunjee

Added .isUndefined which I use all the time in Javascript. Don't think it'll see much use in ahk but could be wrong.

Chunjee

I've added https://biga-ahk.github.io/biga.ahk/#/?id=isundefined to biga.ahk to address cases like this. Perhaps that is of use to you. But if you are struggling with basics it may not be.

Code: Select all

A:= new biga()

A.isUndefined(neverIntializedVar)
; => true

A.isUndefined("")
; => true

Chunjee

I recently had a very good experience with creating a site using https://handlebarsjs.com Was able to do a lot of logic in the generation process and used a responsive html template from https://themeforest.net/category/site-templates to save time on design and frontend pixel pushing. Would recommen...

Chunjee

Wish I could find it again but some article I read a while back convinced me that code comprehension was much more valuable than neat tricks and clever code. The basic argument being that when working with a group, or even a later version or yourself; being able to quickly understand what is going o...

Chunjee

There was a flaw in the logic. Basically every row is matched to every other, encountering the + number or - number would always return a date increase because if it didn't appear as an after date on the first time, the second time the match was encountered it would be. I solved this by assuming we ...

Chunjee

I'm not sure what to do when they have the same date. for example row 77,78 have amounts of "4653" and "-4653" but share the same date of "12/19/2018" Those were counted as NOT matches, and will stay that way unless otherwise noted. The logic works right now by finding the difference for two dates a...

Chunjee

According to this. 4066 items have exact matching offsets, match projects, match vendors, and the negative number adjustment comes after the positive one.

I'm checking that the date comparison logic is valid. I probably won't be writing a new excel file, but let's see how easy it is.

Chunjee

Ok I see what I did wrong. There are many many offsets. I'm re-reading what other conditions have to be met now. Vendor/poroject and date stuff

Chunjee

I've got all the data loaded. It takes about 3 mins to check each value against all other amounts. I must have done something a little wrong because it didn't find any offsets. I think it would probably be a good idea to split the data into sets by each vendor so you don't have to run through every ...

Chunjee

I started with Allman and would recommend it for most AHK scripts as some flows demand it. Changed to K&R/1TBS because if you look at any code examples online that is what you'll likely see and I must have just started "speaking" it after a while. While Allman is probably more explicitly clear, I th...

Chunjee

enigment wrote: ↑
14 Sep 2019, 21:37
I do have Windows key hot keys. What do I need to do so things work correctly with the current version?

Install, lol

Chunjee

I'm going to give this a shot tomorrow morning. I don't have very good access to Excel at home (My wife's laptop has office 365 but not sure about anything programming related)

Chunjee

I think absolutely required. Reading https://www.autohotkey.com/docs/AHKL_ChangeLog.htm it looks like mostly just fixes.

The addition of Object.Count() is why I say required. That was added in 1.1.29.00

Chunjee

Does the script otherwise work when the window is open but not active in the foreground?

I believe that was my experience with ControlClick, but it may depend on the app being clicked.

Chunjee

I'm not sure what kind of output you are looking for but If you're just trying to figure out "is {{x}} anywhere inside this other string" then InStr() would be perfect for you. Alternatively you may also be interested in https://www.npmjs.com/package/string-similarity.ahk which returns a "percentage...

Search found 1499 matches

Re: Better than Excel? Nested match offsetting amounts for accounting

Re: count file and sum in folder by criteria

Re: count file and sum in folder by criteria

Re: Create variables from JSON file Topic is solved

Re: How to check if a string contains text or is it empty?

Re: [help needed] utility library

Re: How to check if a string contains text or is it empty?

Re: html/websites: resources

Re: your personal AutoHotkey style guide

Re: Better than Excel? Nested match offsetting amounts for accounting

Re: Better than Excel? Nested match offsetting amounts for accounting

Re: Better than Excel? Nested match offsetting amounts for accounting

Re: Better than Excel? Nested match offsetting amounts for accounting

Re: Better than Excel? Nested match offsetting amounts for accounting

Re: Allman style v. K&R style/one true brace style

Re: How risky is upgrading from 1.1.24.04 to current 1.1.30.03?

Re: Better than Excel? Nested match offsetting amounts for accounting

Re: How risky is upgrading from 1.1.24.04 to current 1.1.30.03?

Re: Help with a Background script Topic is solved

Re: Identifying unique strings in a block of text