Vista - Output all content of text file in different columns

Below is a simple script that i've done. I'm willing to output all the
content of the file "test.txt" when i run the command "$mycol | format-table
-auto". Unfortunately the only result that i get is the last input.

$a = read-host "Num"
$b = read-host "Num"
$c = read-host "Num"

$d = "$a : $b : $c"

write-output "$d" | out-file "f:\test.txt" -append


$mycol = @()

$colItems = get-content f:\test.txt

foreach ($d in $colItems) {
$myobj = "" | Select-Object A,B,C
$myobj.A = $a
$myobj.B = $b
$myobj.C = $c
$myCol = $myobj

}

$mycol | format-table -auto

The main reason you are only seeing the last input is that you are setting
your colums to equal what you just input

$myobj.A = $a
$myobj.B = $b
$myobj.C = $c

You used $a, $b and $c as your input variables for the three read-host lines

An easier way to display the contents is like this. Change your output
file to a csv file and give it a header row of A,B,C. Change your script to

$a = read-host "Num"
$b = read-host "Num"
$c = read-host "Num"

$d = "$a,$b,$c"

out-file -InputObject $d -FilePath "c:\test\test2.csv" -append

import-csv "c:\test\test2.csv" | format-table -auto


Your file will look like this

A,B,C
5,6,7
1,2,3

etc

--
Richard Siddaway
All scripts are supplied "as is" and with no warranty
PowerShell MVP
Blog: http://richardsiddaway.spaces.live.com/
PowerShell User Group: http://www.get-psuguk.org.uk


"Jason1008" wrote:

Split the line, trim each split value, and set the object's properties through multiple assignment. Use the += operator to append the new object to the collection:

$mycol = @()
$colItems = get-content f:\test.txt
foreach ($d in $colItems) {
$myobj = "" | Select-Object A,B,C
$myobj.A, $myobj.B, $myobj.C = $d.split(':') | % {$_.trim()}
$myCol += $myobj
}
$mycol | format-table -auto

--
Kiron

Thank a lot. It work perfectly.



"Kiron" wrote: