Skip to content

Instantly share code, notes, and snippets.

View mark05e's full-sized avatar

mark05E mark05e

64 followers · 392 following
View GitHub Profile
@mark05e
mark05e / cyberchef-excelcleanup.md
Created September 26, 2024 17:00

Excel Data Cleanup with cyberchef

CHEF Format

Find_/_Replace({'option':'Simple string','string':'""'},'"',true,false,true,false)
Find_/_Replace({'option':'Regex','string':'"CASE'},'CASE',true,false,true,false)
Find_/_Replace({'option':'Simple string','string':'}"'},'}',true,false,true,false)

Recipie Demo

@mark05e
mark05e / dialnumber.js
Created September 21, 2024 15:30
// https://ringcentral.github.io/ringcentral-embeddable/
function dialNumber(number) {
const buttonSelector = "#viewport > div > div > div.sc-eIcdZJ.czoGgN > div.sc-BQMaI.bHaYic > div.sc-epqpcT.cBEqvY > div > div.sc-gvPdwL.lcuqyY > div.sc-ggqIjW.gfQTjQ > div > button:nth-child({index})";
const digits = number.toString().split('');
const delay = 500; // 50ms delay between each press
digits.forEach((digit, index) => {
setTimeout(() => {
@mark05e
mark05e / determine if Im in powershell or cmd.md
Created September 4, 2024 11:26
Determine if I'm in powershell or cmd 
(dir 2>&1 *`|echo CMD);&<# rem #>echo PowerShell

(dir 2>&1 *`|echo CMD);&<# rem #>echo ($PSVersionTable).PSEdition

Reference:

@mark05e
mark05e / Amazon Connect Training Resources.md
Created August 18, 2024 21:40
@mark05e
mark05e / CalendarLink-Demo.html
Last active August 18, 2024 16:14
Calendar Link Demo - https://jsfiddle.net/t586qyd7/2/
@mark05e
mark05e / browser-based-tools.md
Last active July 31, 2024 01:03
@mark05e
mark05e / postman-scripts.md
Last active June 19, 2024 02:05

Postman Scripts

Write OAuth to environment variables

// Write OAuth to environment variables
if (pm.response.code == 200) {
    const responseJson = pm.response.json();

    const access_token = responseJson.access_token;
    pm.environment.set("__access_token", access_token)
@mark05e
mark05e / xmlnotepad-comment.ahk
Last active June 17, 2024 19:12
XML Notepad - Performs keyboard shortcuts to comment and uncomment nodes
; Author: mark05e, Gemini/Bard (Large Language Model by Google)
; Description: Performs keyboard shortcuts to comment and uncomment nodes within XML Notepad.
; - Ctrl + / or Ctrl + K: Simulates menu key press followed by "h" and "o" keys (for commenting)
; - Ctrl + Shift + / or Ctrl + Shift + K: Simulates menu key press followed by "h" and "e" keys (for uncommenting)
; References:
; - https://www.reddit.com/r/AutoHotkey/comments/xrfk3c/mouse_right_click_and_select_an_action_from/
; - https://github.com/microsoft/XmlNotepad/issues/396
; - https://www.autohotkey.com/boards/viewtopic.php?t=38761
; Hotkeys:
; - Ctrl + /
@mark05e
mark05e / Get-IniFile.ps1
Last active July 31, 2024 01:03
Reads an INI file and parses it into a hashtable structure. From https://stackoverflow.com/questions/43690336/powershell-to-read-single-value-from-simple-ini-file
# https://stackoverflow.com/questions/43690336/powershell-to-read-single-value-from-simple-ini-file
function Get-IniFile
{
param(
# Required parameter specifying the path to the INI file.
[parameter(Mandatory = $true)] [string] $filePath
)
$anonymous = "NoSection"
@mark05e
mark05e / Personal Finance CC Expence Category Report.gs.js
Last active May 12, 2024 05:43
// Sheet 1 - Description,Category
// Sheet 2 - CC Transactions.
// Run main() with Sheet 2 active.
function insertTitle(sheet, destinationColumnName, title) {
console.log(destinationColumnName)
var titleCell = sheet.getRange(destinationColumnName + "1");
titleCell.setValue(title);
}