ninmonkey

I used pseudocode to shorten the example. The structure is good.

Using nested let

let
    Source1 =
        let 
            Workbook = File.Contents(...),
            Final    = Table.SelectColumns( ... )

ninmonkey

function NewUser {
    <#
    .synopsis
        Create a new user with a name. Any "blank" values will fallback with a default value

    .DESCRIPTION
        If you use ValidateIfNotSomething, invalid or missing values throws.
        
        - Sometimes you want the command that always works, with a fallback value
        - $null, empty string to count as blank

ninmonkey

using namespace System.Collections.Generic
<#
Using: Pwsh 7
Related:
    For parsing HTML with CSS Selector queries, see this template: <https://gist.github.com/ninmonkey/17f6a1f5b28249b6cb2ba8bc746ae4fb>
#>


function FindArchivedUrl {
    <#

ninmonkey

About

I'm experimenting with collisions for the Env var RFC: PowerShell/PowerShell-RFC#384

Cases

Case: fails as expected

$h1 = @{ "path"      = 'foo\bar' }
$h2 = @{ "path`u{0}" = '' }

ninmonkey

function InvokeWingetInstall { 
    <# 
    .synopsis
        example of using native commands with dynamic conditions. 
    .example  
    # example commands: Use -TestOnly and -Verbose to see cli arguments, without invoking it.
    
    InvokeWingetInstall -Verbose -Package 'Microsoft.PowerBI' -TestOnly -Silent
    VERBOSE: install --id Microsoft.PowerBI /silent
    

ninmonkey

# I'm explicitly unloading the module for each test
Remove-Module ImportExcel -ea 'ignore'
(Get-Module ImportExcel).IterCommands.count
# out: 0

Remove-Module ImportExcel -ea 'ignore'
(Get-Module ImportExcel).count 
# out: 0

Remove-Module ImportExcel -ea 'ignore'

ninmonkey

About

Compare if NaN fails a round trip in Powershell or when using System.Text.Json

Ran using: pwsh.exe 7.4. context

Tests

ninmonkey

SVG's support CSS variables.

CSS variables

Instead of hard coding values in the whole file:

<path fill="#123456" .... >

You can declare a variable named --color-main and resuse it.

ninmonkey

@'
There's a bunch of literals added in 6+
7.1 added
> using a type suffix on a hex literal now returns a signed value of that type

https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.core/about/about_numeric_literals?view=powershell-7.5
'@


100 - 93.79         | ty 'i int, i d'

ninmonkey

$originalMessage = "hi 🐒 world"

$enc     = [Text.Encoding]::GetEncoding('utf-8')
$bytes   = $enc.GetBytes( $originalMessage)
$hexStr  = [Convert]::ToHexString( $bytes )
$asBytes = [Convert]::FromHexString( $hexStr )

$roundTrip = $enc.GetString( $AsBytes )

[pscustomobject]@{