Skip to content

Instantly share code, notes, and snippets.

View ninmonkey's full-sized avatar

Jake Bolton ninmonkey

44 followers · 90 following
View GitHub Profile
@ninmonkey
ninmonkey / Simple-EscapeControlChar.ps1
Created October 12, 2025 20:50
Tiny Escape Control Char Pwsh7
filter EscapeCC {
($_)?.EnumerateRunes() | % {
($_.Value -le 32) ? [Text.Rune]( $_.Value + 0x2400 ) : $_
} | Join-String
}
"sdf `a sdjf hi world`t`n ${fg:#feaa99} more stuff `u{0} `r`n blah" | escapeCC
# outputs: sdf␠␇␠sdjf␠hi␠world␉␊␠␛[38;2;254;170;153m␠more␠stuff␠␀␠␍␊␠blah
@ninmonkey
ninmonkey / Combine-Table.AddRows.pq
Created July 19, 2025 21:22
Merge multiple `Table.AddRows` and schema transforms into fewer steps
let
startDate = DateTime.Date( DateTime.LocalNow() ),
endingOffset = 1000, // in days
endingOffsetDate = Date.AddDays( startDate, endingOffset ),
allDays = List.Transform(
{ Number.From(startDate)..Number.From(endingOffsetDate) },
each { Date.From( _ ) }
),
@ninmonkey
ninmonkey / Using Powershell New or Assignment.md
Last active May 17, 2025 17:46
Testing `type = @( $data )` and `[type]::new( $data )`

Explicitly calling ::new()

using namespace System.Collections.Generic
$example = 9, 4, 3

[List[int]]::new( [int[]]$example )
  • I had to type it as an [int[]]
@ninmonkey
ninmonkey / BasicTable.html
Last active May 16, 2025 19:04
Focing Html with 3 columns to `<table>` to share column widths
<html><body>
<table class="cols-3">
<tr>
<th>Company</th>
<th>Contact</th>
<th>Country</th>
</tr>
<tr>
<td>Alfreds Futterkiste</td>
<td>Maria Anders</td>
@ninmonkey
ninmonkey / Saving-Excel-Workbook-As-Base64-Round-Trip.pq
Last active April 25, 2025 17:14
Saving-Excel-Workbook-As-Base64-Round-Trip.pq
let
Path_Xlsx = "c:\data\workbook.xlsx",
Summary = [
// [1] using "enter-data" saves a table as json like this
b64_str = "i45WSkosUoqNBQA=",
bytes = Binary.FromText( b64_str, BinaryEncoding.Base64),
bytes_decompressed = Binary.Decompress( bytes, Compression.Deflate),
final_json_str = Text.FromBinary( bytes_decompressed, TextEncoding.Utf8 ),
// [2] converting some binary file to base64
@ninmonkey
ninmonkey / PwshClass▸Using▸Text.Json.ps1
Last active April 20, 2025 21:06
AutoJson.Basic-Text.Json.md
#Requires -Version 7
using namespace System.Collections.Generic
using namespace System.Text
using namespace System.Text.Json
using namespace System.Text.Json.Serialization
using namespace System.Linq
$assembly = Add-type -AssemblyName System.Text.Json -PassThru -ea 'stop'
<#
@ninmonkey
ninmonkey / Strip-Shared-Predent-Text-Like-Python.ps1
Last active April 7, 2025 20:29
Strip-Shared-Predented-Text-Like-Python.ps1
$longMessage = @"
This is a long message.
It has several lines.
Some are indented
more than others.
Some should start at the first column.
Some have "quoted text" in them.
"@
function TrimPredent {
@ninmonkey
ninmonkey / Microtopia Hunger.cs
Last active March 27, 2025 00:15
Microtopia Hunger.md
void updateHunger() {
// applied about every 1 second?
curDrain = GetCurrentDrain();
energy -= curDrain // but clamps to keep it >= 0
newTier = GetTier( energy )
if ( newTier != curTier ) {
SetTier( newTier )
}
}
@ninmonkey
ninmonkey / Experiment with SplitByTextWhitespace.md
Last active March 19, 2025 22:06
Power Query and splitting by multiple whitespace

This function works sort of like calling Regex.Split with this regex

\s+

Here's fun way to experiment

let
@ninmonkey
ninmonkey / QuickCompare-TextEncoding.ps1
Last active March 5, 2025 00:33
Assumes pwsh7. Decode a few strings with mismatched encodings
# Assumes pwsh7
# tip: pwsh 7 added overloads
$StrIn = 'Г¶'
$bytes = [Text.Encoding]::GetEncoding(1252).GetBytes( $StrIn )
$Bytes = [Text.Encoding]::GetEncoding('utf-8').GetString( $bytes )
# and also
$StrIn.EnumerateRunes | Ft -auto