Use the -delimiter parameter specified in the online help for export-csv
$DataSet.Tables[0] | Export-csv "G:\Text.txt" -NoTypeInformation -delimiter "|"
Bob Klimes
- 3.3k
- 1
- 19
- 30