Formatting data in PowerShell

Question

I am trying to read the data and write it into a .txt file using PowerShell.

But the in the result it get trimmed.

#Get the photo path of the students 
$commandAD = $connection.CreateCommand()

#Retrieving student photo records.
$commandAD.CommandText = "SELECT [Barcode],[ImageURL]   FROM 
[iSAMS_Custom].[dbo].[vwDestinyLibrary_Student_photo1]"
$resultPhoto = $commandAD.ExecuteReader()
$tablePhoto = new-object "System.Data.DataTable"
$tablePhoto.Load($resultPhoto)

#Export Hash Table to Txt File
$tablePhoto | Out-File c:\Users\nimmy.pk\Documents\inputphoto.txt

How I can format the data?

Maybe save it as a csv, it seems like the object is a table

guiwhatsthat
– guiwhatsthat

2017-10-19 09:06:04 +00:00
Commented Oct 19, 2017 at 9:06 — guiwhatsthat
– guiwhatsthat, Commented Oct 19, 2017 at 9:06
I need the result as in txt format

nimmy pk
– nimmy pk

2017-10-19 09:07:34 +00:00
Commented Oct 19, 2017 at 9:07 — nimmy pk
– nimmy pk, Commented Oct 19, 2017 at 9:07

Olaf Reitz · Accepted Answer · 2017-10-19 09:29:59Z

2

You can use the -Width parameter from Out-File:

$tablePhoto | Out-File -Width 4096 -Path c:\Users\nimmy.pk\Documents\inputphoto.txt

answered Oct 19, 2017 at 9:29

Olaf Reitz

7143 silver badges10 bronze badges

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

3 Comments

nimmy pk Over a year ago

now the url showing completely, but all the results showing in a single column rather than in two.

nimmy pk Over a year ago

I tried to delete the blank spaces between the columns but it doesn't work :( ... I am quite new to PowerShell and recently started learning. Anyone can help on the formatting of the output file to see the full result???

Olaf Reitz Over a year ago

The use a CSV like @guiwhatsthat mentioned, $tablePhoto | Export-CSV -delimiter "`t" -path c:\Users\nimmy.pk\Documents\inputphoto.txt

Collectives™ on Stack Overflow

Formatting data in PowerShell

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related