ninmonkey

# This is a ps5 + ps7 script
# ps5 writes errors when PBI refreshes, ps7 either never does, or its much, much more rare

$dest    = 'C:\Users\cppmo_000\AppData\Local\Temp\cults.csv'
$iter = 0
while($true) {
   $iter++
   $Last    = [datetime]::Now
   $content = w32tm /stripchart /computer:time.google.com /samples:1 /dataonly
   Add-Content -Path $dest -Value (

ninmonkey

Sometimes line continuations are quite permissive

Starting code

[datetime]::ParseExact( 'septiembre', 'MMMM', (get-culture 'es') ).ToString('MMMM', (get-culture 'es'))

[a]

ninmonkey

How can you convert a text column with SEPTIEMBER as a spanish month name to a date or even english name?

1. specifically choose spanish es as your culture/locale in your "transform column types" step
2. If that's not automatic, pick the format string for month names

Here's Power Query to prove it

[ 

ninmonkey

TL; DR;

You need to use utf-8 with the BOM. Then excel opens it automatically. No transforms, no get-data is required.

How to generate unicode test files

Here's a powershell script:

$rows = @( 

ninmonkey

using namespace System.Management.Automation
using namespace System.Management.Automation.Language

$Tokens = $null
$AstErrors = $Null
$doc = [Parser]::ParseFile(
    <# fileName: #> $file,
    <# tokens  : #> [ref] $tokens,
    <# errors  : #> [ref] $AstErrors )

ninmonkey

[xml]$doc = gc (Join-Path $PSScriptRoot './sample.xml')

[xml]$Doc = @'
<?xml version="1.0" encoding="utf-8"?>
<configuration>
    <setting name = "logLevel" value = "verbose" />
    <setting name = "root" value = "c:/foo" desc = "users root dir" />
</configuration>
'@

ninmonkey

function Format-ControlChar { 
    <#
    .synopsis
       converts ANSI control chars into human-visible symbols. 
    .description    
      Because they are not ansi escapes ( control chars ), they have no special meaning
      so they are save to pipe to your terminal or transport.   
      
      This is written in for Pwsh7 because it simplifes code
    #>

ninmonkey

let
    /* testing delays in query diagnostics */
    seconds = 5,
    resp1 = [ 
        Bytes = Web.Contents( "https://httpbin.org", [ RelativePath = "/links/3/1" ] ),
        Who = Diagnostics.ActivityId()
    ],

    resp2 = 
        Function.InvokeAfter( 

ninmonkey

#Requires -Module 'PSParseHtml'
<#
.Synopsis
    Combining a simple `CSS` / `XPath` query with regex works fairly well to find `icon` resources
#>

[Uri] $Url = 'https://na.alienwarearena.com'
$xpath_doc ??= ConvertFrom-Html -Url $Url -Engine AgilityPack
$css_doc   ??= ConvertFrom-Html -Url $Url -Engine AngleSharp

ninmonkey

More info / Docs :

• REST API's GZip response body isn't decoded @ /powershell/powershell/issues
• Discord thread
• Unable to override Accept-Encoding header with Invoke-WebRequest in version 7.4.1 #21205
• [System.Net.Http.HttpClientHandler.AutomaticDecompression]

OP was using the same Invoke-WebRequest|RestMethod code on Ps5 and Ps7 with different results.

• One returned text
• The other was still gzipped