Hi folks,

I'm on Powershell since a week now, so I still got typical beginner problems. This is my current one:

I got a two dimensional array. Let's call it $array with the values 1, 2 and 3 in the first row an a, b and c in the second.

Now I want to put the content of the array in a csv in the following order:

line 1: 1;2;3

line 2: a;b;c

How can I achieve that? I think I need an output variable for each line, but I'm getting errors by filling that one. This is one of my several tests with combinations of brackets and quotes:

foreach ($row in $arrayΎ .. ($array.count -1)]) {
    $output = "$row[0];$row[1];$row[2]"
    Write-Output $output | Out-Host
  }

Can you guys help me?

Hi Shay,

this is the summary of my problem. I figured out a workaround to get the output I want, but this is not the kind of solutions I prefer.

function create_line([string] $dn)
  $line = @()
  $line += $dn.split(",")[ 0].replace('"CN=', "").replace("\", "")
  $line += $dn.split(",")[ 1].replace(" ", "")
  $line += (dsget user $dn -disabled)[ 1]
  $line += $dn.split(",")[ 2].replace("OU=", "")
  $usrlist += $line
}
# --Main--
$usrlist = @()
$usr_accounts = dsquery user "ou=user,dc=example,dc=net" -limit 0
foreach($usr in $usr_accounts) {
  create_line $usr
}
foreach ($ln in $usrlist) {
  $op0 = $ln[ 0]
  $op1 = $ln[ 1]
  $op2 = $ln[ 2]
  $op3 = $ln[ 3]
  $output = "$op0;$op1;$op2;$op3"
  Write-Output $output | Out-File -path "D:\scripts\Accountlists\User.csv" -append
}

Thanks in advance!