Vista - Import-CSV Exchange Powershell:How to use ";"

Hi at all,

i want to create mailboxes with the import-csv command. But the columns are
separated with a semicolon (. How could i set a ";" as a -delimiter?

Kind regards

I thank all for the replies,
but one questio:

what to do if i could not replace the ; cause the import.csv have columns
with values which need a "," ???

Am i able to upgrade the powershell to ctp 2 without damaging my exchange
management shell??

Kind regards

This function should work ok in v1. Let me know if there's any problems.

function Import-Delimited([String]$Path,[Char]$Delimiter="`t",[Switch]$Wait)
{

$HeadersProcessed = $false

filter ProcessLine {

if ($HeadersProcessed) {

$Fields = @($_.Split($Delimiter) | %{ $_.Trim() })

$OutputObject = New-Object PSObject
for ($i = 0; $i -lt [Math]::Min($Headers.Length,$Fields.Length);
$i++) {
Add-Member -InputObject $OutputObject NoteProperty
$Headers[$i] $Fields[$i]
}
$OutputObject

}
else {
$Headers = @($_.Split($Delimiter) | %{ $_.Trim() })
$HeadersProcessed = $true
}
}

if ($Wait) { Get-Content $Path -Wait | ProcessLine }
else { Get-Content $Path | ProcessLine }

}


"Help20030303" <Help20030303@xxxxxx> wrote in message
news:98869451-4FC5-404E-A39C-B859B56539E8@xxxxxx

I wouldn't upgrade to CTP on a production Exchange server ... but as far
as I know there haven't been any known compatibility glitches.

There's a Import-Delimited script with a Convert-Delimiter function on
PoshCode that you could use, it should handle virtually any use case...
http://poshcode.org/search/delimiter
--
Joel



Help20030303 wrote: