Creating/Formatting a .txt file from Powershell

Question

I'm trying to export a table from sql and save it as an .txt using powershell. However, when I open my .txt file the data is not in table format

This is the format of my .txt file:

Name : Billy Bob Address : Nowhere Rd State : NA Number : 999-999-9999

I would like for my .txt to be written in this format:

Name, Address, State, Number Billy Bob, Nowhere Rd, NA, 999-999-9999

Or even this format will do, where the space between each column is the tab key

 Name Address State Number Billy Bob Nowhere Rd NA 999-999-9999

CB. · Accepted Answer · 2011-09-12 14:37:49Z

3

without your code is not easy help you but if $a is a variable containinng the exported SQL table try this:

$a | export-csv "my.txt"

answered Sep 12, 2011 at 14:37

61.3k9 gold badges171 silver badges165 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Powershell reads a sql query then output the query into an .txt file

Here is the code that create the .txt file. The file name is try2.txt <p>$DataSet.tables[0] | Out-File C:\example\try2.txt </p> Thanks

use export-csv instead out-file for have a file with comma separed values