CSV, XML и табличные данные

$result = & { Import-Csv .\data.csv -Delimiter ";" -Encoding utf8 }
$resultType = if($null -eq $result){'<null>'}else{$result.GetType().FullName}
[pscustomobject]@{ Result=$result; Type=$resultType; Count=@($result).Count }

$result = Import-Csv .\data.csv -Header Id,Name,Amount
$items = @($result)
[pscustomobject]@{ Count=$items.Count; First=$items | Select-Object -First 1; IsNull=($null -eq $result) }

$result = Get-Content .\data.csv -First 1
$resultType = if($null -eq $result){'<null>'}else{$result.GetType().FullName}
[pscustomobject]@{ Result=$result; Type=$resultType; Count=@($result).Count }

Import-Csv .\data.csv | ForEach-Object {[pscustomobject]@{Id=$_.Id;Amount=[decimal]::Parse($_.Amount,[Globalization.CultureInfo]::InvariantCulture)}}

$result = [datetimeoffset]::ParseExact($row.At,"o",[Globalization.CultureInfo]::InvariantCulture)
$summary = [ordered]@{ IsNull=($null -eq $result); Count=@($result).Count }
if($null -ne $result){$summary.Type=$result.GetType().FullName};[pscustomobject]$summary

switch -Regex ($row.Enabled){"^(?i:true|yes|1)$"{$true};"^(?i:false|no|0)$"{$false};default{throw "bad boolean"}}

[xml]$doc=Get-Content .\config.xml -Raw
$doc.configuration.appSettings.add

$ns=[Xml.XmlNamespaceManager]::new($doc.NameTable);$ns.AddNamespace("x","urn:demo");$doc.SelectNodes("//x:item",$ns)

$settings=[Xml.XmlReaderSettings]::new();$settings.DtdProcessing=[Xml.DtdProcessing]::Prohibit
$valueType = if($null -eq $settings){'<null>'}else{$settings.GetType().FullName}
[pscustomobject]@{ Value=$settings; Type=$valueType; Count=@($settings).Count }

$required="Id","Name","Amount";$headers=(Get-Content .\data.csv -First 1)|ConvertFrom-Csv|Get-Member -MemberType NoteProperty|Select-Object -Expand Name

$version=$doc.DocumentElement.GetAttribute("schemaVersion")
$valueType = if($null -eq $version){'<null>'}else{$version.GetType().FullName}
[pscustomobject]@{ Value=$version; Type=$valueType; Count=@($version).Count }

$map=@{customer_id="CustomerId";total="Amount"}
$valueType = if($null -eq $map){'<null>'}else{$map.GetType().FullName}
[pscustomobject]@{ Value=$map; Type=$valueType; Count=@($map).Count }

$a=Import-Csv .\in.csv;$a|Export-Csv .\out.csv -NoTypeInformation;$b=Import-Csv .\out.csv;"$($a.Count):$($b.Count)"

# Сценарий для ревью: Числа испортились на другой локали.
$path = '.\incoming\data.csv'
$hashBefore = (Get-FileHash -LiteralPath $path).Hash
$rows = Import-Csv -LiteralPath $path
$hashAfter = (Get-FileHash -LiteralPath $path).Hash
[pscustomobject]@{ Rows=$rows.Count; Stable=($hashBefore -eq $hashAfter); Culture=[cultureinfo]::CurrentCulture.Name }

# Сценарий для ревью: XPath ничего не находит.
$settings = [Xml.XmlReaderSettings]::new()
$settings.DtdProcessing = [Xml.DtdProcessing]::Parse
$reader = [Xml.XmlReader]::Create('.\input.xml',$settings)
$doc = [Xml.XmlDocument]::new(); $doc.Load($reader); $doc.SelectNodes('//*')

$safe=if($value -match "^[=+\-@]"){"'$value"}else{$value}
$valueType = if($null -eq $safe){'<null>'}else{$safe.GetType().FullName}
[pscustomobject]@{ Value=$safe; Type=$valueType; Count=@($safe).Count }

# Сценарий для ревью: XML принимает DTD.
$settings = [Xml.XmlReaderSettings]::new()
$settings.DtdProcessing = [Xml.DtdProcessing]::Parse
$reader = [Xml.XmlReader]::Create('.\input.xml',$settings)
$doc = [Xml.XmlDocument]::new(); $doc.Load($reader); $doc.SelectNodes('//*')

# Сценарий для ревью: Импортируемый файл заменяется во время чтения.
$path = '.\incoming\data.csv'
$hashBefore = (Get-FileHash -LiteralPath $path).Hash
$rows = Import-Csv -LiteralPath $path
$hashAfter = (Get-FileHash -LiteralPath $path).Hash
[pscustomobject]@{ Rows=$rows.Count; Stable=($hashBefore -eq $hashAfter); Culture=[cultureinfo]::CurrentCulture.Name }