How to create newline on csv file from powershell

Question

I am stuck on a point where I have two array variables like this

$name = @("A","B","C")

$roll = @("1","2","3")

and I am trying to make a csv file with this data. I am using this code

$name = @("A","B","C")
$roll = @("1","2","3")
$report = New-Object psobject
$report | Add-Member -MemberType NoteProperty -Name "Name" -Value "$name"
$report | Add-Member -MemberType NoteProperty -Name "Roll" -Value "$roll"
$report | Export-Csv -Path "C:\Users\Abby\Desktop\r.csv" -NoTypeInformation

But I have a output like this

NAME | ROll

A B C| 1 2 3

I want my output like this

NAME | ROll

A | 1

B | 2

C | 3

Can any one have any idea how to do these... Please help me... :(

G42 · Accepted Answer · 2017-11-01 12:24:45Z

2

You current code is creating the object, and adding the arrays $name and $roll as single entries.

It sounds like you want an entry for each value in your array. Assuming the arrays are the same length, you could iterate over the values:

$name = @("A","B","C")
$roll = @("1","2","3")

foreach($i in 0..($name.Count -1)){
    [array]$report += [pscustomobject] @{
        Name = $name[$i]
        Roll = $roll[$i]
    }
}

# screen output
# $report | Format-Table

$report | Export-Csv -Path "C:\Users\Abby\Desktop\r.csv" -NoTypeInformation

Screen Output

Name Roll
---- ----
A    1
B    2
C    3

answered Nov 1, 2017 at 12:24

G42

10.1k2 gold badges22 silver badges36 bronze badges

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

1 Comment

G42 Over a year ago

@KunalMajumder NP! If it's resolved your issue, please consider accepting

Esperento57 · Accepted Answer · 2017-11-01 20:07:38Z

1

try this:

$name = "A","B","C"
$roll = "1","2","3" 
$index = 0
$name | %{[pscustomobject]@{Name=$_;Roll=$roll[$index++]}} |Export-csv "C:\Users\Abby\Desktop\r.csv" -NoType

answered Nov 1, 2017 at 20:07

Esperento57

17.6k6 gold badges42 silver badges47 bronze badges

Collectives™ on Stack Overflow

How to create newline on csv file from powershell

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related