cd "C:\archived\self\task\powershell\test\Other"
cls
Get-Date
$bcpFileCDSIssuerMirror = "GCDR.all_issuers.data.20100921.bcp"
$bcpFileCDSIssuerColumnsRemoved = "bcpFileCDSIssuerColumnsRemoved"
if ((Test-Path "$bcpFileCDSIssuerColumnsRemoved" -PathType Leaf) -eq $true)
{
Remove-Item $bcpFileCDSIssuerColumnsRemoved
}
$OFS = "|"
Get-Content $bcpFileCDSIssuerMirror -ReadCount 50000 |%{
$itemArrayArray =@()
foreach($item in $_)
{
$itemArray = $item.Split('|')
$itemArray =$itemArray[0..4 + 6..10 + 11..($itemArray.Length-1)]
#$temp = [String]::Join("|", $itemArray)
$itemArrayArray += "$itemArray"
}
$itemArrayArray
}|Out-File $bcpFileCDSIssuerColumnsRemoved -Encoding Ascii
Get-Date
