PSKit

1.2.0

ConvertFromFixedData.ps1

<#
    .SYNOPSIS
    Convert your fixed-width file into a PowerShell Array using a CSV-formatted schema
 
    .EXAMPLE
    ConvertFrom-FixedData -fixedData (Get-Content .\data\fixedData.txt) -schema (Import-Csv .\data\fixedDataSchema.csv)
 
name age cash
---- --- ----
Chris 44 72
Brian 26 110
Ryan 18 145
Joe 34 83
#>

function ConvertFrom-FixedData {
    param(
        $fixedData,
        $schema
    )

    foreach ($record in $fixedData) {
        $h = [ordered]@{ }
        foreach ($schemaRecord in $schema) {
            if ($schemaRecord.length -eq '$') {
                $h.($schemaRecord.column) = $record.SubString($schemaRecord.start - 1)
            }
            else {
                $h.($schemaRecord.column) = $record.SubString($schemaRecord.start - 1, $schemaRecord.length)
            }
        }

        [PSCustomObject]$h
    }
}