Skip to content

Instantly share code, notes, and snippets.

View janasco's full-sized avatar
💭
I may be slow to respond.

Jaymar Anasco janasco

💭
I may be slow to respond.
View GitHub Profile
@marcpinet
marcpinet / README.md
Last active July 8, 2024 14:31
Activate Sublime Text 4 Build 4143 and below for ever (also maybe above, but not yet tried)

Activate Sublime Text (for ever)

  1. Go to https://hexed.it/
  2. Click Open File in the top left corner and select sublime_text.exe
  3. Press CTRL + F or on the Search for bar in the left panel and look for: 80 78 05 00 0f 94 C1
  4. Now in the editor, click on the first byte (80) and start replacing each byte by: C6 40 05 01 48 85 C9
  5. Finally, in the top left corner again, click on Save as and replace the old executable file with the newly created one.

Enjoy an Unlimited User License!

@davemoz
davemoz / Gmail data into Sheet with Google Apps Script
Last active April 4, 2024 09:00
Google Apps Script to pull data from transaction emails in Gmail, and insert into Spreadsheet
/*
* This Google Apps Script works by simply scraping info from transaction emails
* sent to your Gmail account.
* My credit cards are Capital One, Chase, and Bank of America so the email-scraping
* regexes will need to change to work with the format of your emails.
*
* Once installed, you'll need to set a monthly trigger to run the createMonthlySheet()
* function, but then it will run automatically and sort your transactions into monthly sheets.
*
* Any reference to the getActiveSpreadsheet() method will create a new sheet