I need to delete the first two columns in a CSV. I do not know the header names, they are not static. I figured out how to remove the first two rows, but not the first two columns. The sample code I am working with is below
$csv = Import-Csv 'input.csv'
$headers = $csv[0].PSObject.Properties | select -Expand Name
$step = 4
for ($i = 0; $i -lt $headers.Count; $i += $step) {
$csv | select $headers[$i..($i+$step-1)] |
Export-Csv "output_$($i/$step).csv" -NoType
}
If you wanted to skip the first X columns you just need to adjust your $headers statement
$headers = $csv[0].PSObject.Properties | select -Skip 2 -Expand Name
The above would skip the first 2 columns by not processing the first 2 headers. The rest of the code will group columns of 4 after those 2.
This seems to work:
$csv = Import-Csv 'input.csv'
$include = $csv[0].psobject.properties | select -ExpandProperty Name -Skip 2
$csv | select $include -skip 2 | export-csv output.csv -NoTypeInformation
That should take care of pruning off the first 2 columns and then skipping the first 2 rows.
I think just changing the 0 in the for loop to a 2 should do it:
$csv = Import-Csv 'input.csv'
$headers = $csv[0].PSObject.Properties | select -Expand Name
$step = 4
for ($i = 2; $i -lt $headers.Count; $i += $step) {
$csv | select $headers[$i..($i+$step-1)] |
Export-Csv "new_output_$($i/$step).csv" -NoType
}
$headers[$i..($i+$step-1)]