ReadCsv.ps1
|
function Read-Csv { <# .Synopsis Read comma-separated values (csv). $target can be a URL, a file, or a string .Example #$file = "targetData.csv" $url = 'https://raw.githubusercontent.com/dfinke/ImportExcel/master/Examples/JustCharts/TargetData.csv' $str = @" "Cost","Date","Name" "1.1","1/1/2015","John" "2.1","1/2/2015","Tom" "5.1","1/2/2015","Dick" "11.1","1/2/2015","Harry" "7.1","1/2/2015","Jane" "22.1","1/2/2015","Mary" "32.1","1/2/2015","Liz" "@ $str, $url | Read-Csv Cost Date Name ---- ---- ---- 1.1 1/1/2015 John 2.1 1/2/2015 Tom 5.1 1/2/2015 Dick 11.1 1/2/2015 Harry 7.1 1/2/2015 Jane 22.1 1/2/2015 Mary 32.1 1/2/2015 Liz 1.1 1/1/2015 John 2.1 1/2/2015 Tom 5.1 1/2/2015 Dick 11.1 1/2/2015 Harry 7.1 1/2/2015 Jane 22.1 1/2/2015 Mary 32.1 1/2/2015 Liz #> param( [Parameter(ValueFromPipeline)] $target, $Delimiter = "," ) Process { if ([System.Uri]::IsWellFormedUriString($target, [System.UriKind]::Absolute)) { ConvertFrom-Csv (Invoke-RestMethod $target) -Delimiter $Delimiter } elseif (Test-Path $target -ErrorAction SilentlyContinue) { Import-Csv $target -Delimiter $Delimiter } else { ConvertFrom-Csv $target -Delimiter $Delimiter } } } |