Powershell - Add header during input-csv command

Question

I'm looking for adding header to a csv file without header, and without information about columns number.

I have this code for csv file which I know column count :

    $Content = Import-Csv "C:\temp\input.csv" -Delimiter ';' -Header "1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23"

Which is the best way to create an header like mine, automatically ? Is "Header" parameter can be an arraylist of string value ?

I should code something like this :

$array = New-Object System.Collections.ArrayList
for ($i=1; $i -lt $Columns; $i++)
{
        $array.add($i.ToString())
}

In fact, I wanted to create an header without hardcoding column value, in order to use it for any csv input file. see below my auto answer ;) — freud44
– freud44, Commented Feb 23, 2018 at 8:59
Great; for tidyness I've added it as an answer instead of a comment. — TessellatingHeckler
– TessellatingHeckler, Commented Feb 23, 2018 at 9:05

TessellatingHeckler · Accepted Answer · 2018-02-23 09:05:09Z

2

To make my comment into an answer:

The array construction operator .. makes an array of numbers, e.g. 1..5 is 1, 2, 3, 4, 5 and if you pass an array of numbers to -Header it will be turned into strings automatically, because of the way PowerShell types work - header is expecting a string array.

So you can create an array of however many numbers there are, like so:

-Header (1..$Columns)

answered Feb 23, 2018 at 9:05

TessellatingHeckler

29.3k4 gold badges55 silver badges96 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

freud44 · Accepted Answer · 2018-02-23 08:57:18Z

0

Ok, I've found my error :

$CSVFile = Get-Content $csvTemp
$Columns = ($CSVFile[0].split(";")).Count
[string[]]$tab = @()    
for ($i=1; $i -lt $Columns; $i++){
   $tab+= $i.ToString()
} 
$content = import-csv "c:\temp\test.csv" -delimiter ';' -header $tab

answered Feb 23, 2018 at 8:57

freud44

212 bronze badges

Collectives™ on Stack Overflow

Powershell - Add header during input-csv command

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related