dfinke

function Save-JsonToExcel {
    <#
    .SYNOPSIS
    Saves a JSON string to an Excel file.
    .PARAMETER Json
    The JSON string to save.
    .PARAMETER Path
    The path to save the Excel file to.
    #>
    param(

dfinke

$config = @{
    Preferences     = @{
        defaultAgent = "StockAgent"
    }

    WebSearchAgent  = @{
        Name          = "WebSearch"
        LLM           = New-OpenAIChat 'gpt-4o-mini'
        
        Instructions  = "Today is $(Get-Date)"        

dfinke

function map {
    param(
        $func, 
        [Parameter(ValueFromRemainingArguments = $true)] 
        $arrays
    )

    $arrays | ForEach-Object {
        if ($arrays[0].Length -ne $_.Length) {
            throw "All arrays must be of the same length"

dfinke

$text1 = Read-Host "Enter text"

Set-Clipboard -Value $text1

$text2 = Get-Clipboard

$text2

dfinke

$data = ConvertFrom-Csv @"
Name,UnitsSold
John,100
Jane,200
Tom,120
Jane,300
Jim,150
Mary,250
"@

dfinke

$prompt = "capital of france?"
$model = "gpt-4o-mini"
# $model = "o1-preview"

$headers = @{
    "Content-Type"  = "application/json"
    "Authorization" = "Bearer $($env:GITHUB_TOKEN)"
}

$body = @{

dfinke

param(
    $daysOld = 7
)

$targetDir = $(
    'D:\mygit\GPTIdeas\Experiments\Livestream-GPT\'
    'D:\mygit\PowerShellAIAssistant-ScratchPad'
    'D:\mygit\PSAI'
    'D:\mygit\PSAIAgent-Stealth-2\'
    'D:\temp\Camtasia\scratch\'

dfinke

$sumData = ConvertFrom-Csv @"
ProductName, VendorName, TotalSales
Macbook, Apple
Desktop, DELL
RAM, Lenovo
HDD, HCL
Laptop, IBM
Mouse, Acer
"@

dfinke

# Git-like Diff Tool in PowerShell

function Compare-Files {
    param (
        [string]$OldFilePath,
        [string]$NewFilePath,
        [int]$ContextLines = 3
    )

    $oldFile = Get-Content -Path $OldFilePath

dfinke

# Install-module PSAI
# Get OpenAI API key from https://platform.openai.com/account/api-keys
# Set $env:OpenAIKey

function Compare-PicsUsingAI {
    param(
        $pic1,
        $pic2
    )