powershell format-dataset

powershell format-dataset

cls

function aaa
{
$row3=$table.NewRow();
$row3["BugId1"]="23432"
$row3["BugId2"]="dfdsfbn"
$row3["BugId3"] = 12132
$row3["BugId5"] = "gjghjgjgh"
$table.Rows.Add($row3);
}

#创建数据表对象
$dataset=New-Object -TypeName System.Data.DataSet;
$table = New-Object -TypeName System.Data.DataTable;
$column1=$table.Columns.Add("BugId1",[System.String])
$column2=$table.Columns.Add("BugId2",[System.String])
$column2=$table.Columns.Add("BugId3",[System.String])
$column2=$table.Columns.Add("BugId4",[System.string])
$column2=$table.Columns.Add("BugId5",[System.string])
$row1=$table.NewRow();
$row1["BugId1"] = "   acvbcvbcvbcvbvcbvcbvcbvcbvcbv   "
$row1["BugId2"] = "2342342342342342342   "
$row1["BugId3"] = "234   "

$row2=$table.NewRow();
$row2["BugId1"]="23432"
$row2["BugId2"]="dfdsfbn"
$row2["BugId3"] = "12132"
$row2["BugId5"] = "gjghjgjgh"

$table.Rows.Add($row1);
$table.Rows.Add($row2);
aaa
$dataset.Tables.Add($table)

#echo $dataset.Tables[0].Columns.count
#GetDataSetString $dataset
#echo $dataset.Tables[0].Columns.count

cd "C:\Documents and Settings\jz20247\Desktop\New Folder\DPM"
$dpmQueryOutputFile = "DPMNpositionLoader_DPM_Output"
$positionFile = "${Today_YYYY}.EQRMS_position.txt"

$OFS = "|"
$dataTable = $dataSet.Tables[0]
$datableTableColumnName =@()
foreach($column in $dataTable.Columns)
{
 $datableTableColumnName += $column.ColumnName
}

"$datableTableColumnName" | Out-File $dpmQueryOutputFile -Encoding Ascii
"$datableTableColumnName" | Out-File $positionFile -Encoding Ascii
#$dataTable.Rows | %{"$($_.get_ItemArray())".trim()} | Out-File $dpmQueryOutputFile -Encoding Ascii -Append
#$dataTable.Rows | %{ $item = "$($_.get_ItemArray())" ;if(! $item.Contains(".NaE")){$item.trim()}} | Out-File $positionFile -Encoding Ascii -Append
$dataTable.Rows |  %{$reslut ="$($_.get_ItemArray())".trim();[regex]::Replace($reslut," *\| *","|")} | Out-File $dpmQueryOutputFile -Encoding Ascii -Append
$dataTable.Rows | %{$reslut ="$($_.get_ItemArray())".trim();if(! $reslut.Contains(".NaE")){[regex]::Replace($reslut," *\| *","|")}} | Out-File $positionFile -Encoding Ascii -Append

posted on 2010-12-16 16:10 沙漠鱼 阅读( ...) 评论( ...) 编辑 收藏

转载于:https://www.cnblogs.com/zhaojun20002003/archive/2010/12/16/1908327.html