Display only the columns needed PowerShell

Question

I have to display four columns but three of them each time, the column reference doesn't need to be displayed for a problem of space. This code allows to display cells which aren't in the column reference. When the cells match, the cell in the other columns disappears.

file:

  ComputerName  OtherComputerName   OtherComputer   AndAgain
    infra-1     infra-852            infra-2        infra-99
    infra-98    infra-85             infra-44       infra-23
    infra-5     infra-8              infra-1        infra-10
    infra-2     infra-55             infra-8        infra-70
    infra-62    infra-5              infra-852      infra-5

script:

$csv = Import-Csv .\test1.csv -Delimiter ';'

$ref = @($csv.ComputerName)
foreach ($row in $csv) {
  foreach ($col in 'OtherComputerName', 'OtherComputer', 'AndAgain') {
    if ($ref -contains $row.$col) { $row.$col = '' }
  }
}

$csv

the result on PS: I would like to not display the ComputerName column and retire the space between the cells.

OtherComputerName OtherComputer AndAgain
----------------- ------------- --------
infra-852                       infra-99
infra-85          infra-44      infra-23
infra-8                         infra-10
infra-55          infra-8       infra-70
                  infra-852

the expected result:

OtherComputerName OtherComputer AndAgain
----------------- ------------- --------
infra-852         infra-44      infra-99
infra-85          infra-8       infra-23
infra-8           infra-852     infra-10
infra-55                        infra-70

Use Where-Object to filter output based on whatever criteria you want, and Select-Object to output only the columns you want. — Bill_Stewart
– Bill_Stewart, Commented Jun 19, 2017 at 14:37
Can you show me an example pls i'm a little bit lost. I don't know how to use it. — charlo
– charlo, Commented Jun 19, 2017 at 14:42
Your question is not clear on what conditions you are trying to use. — Bill_Stewart
– Bill_Stewart, Commented Jun 19, 2017 at 14:53

score 6 · Accepted Answer · 2017-06-20 09:48:38Z

6

You can either list all columns/properties to include

$csv | Select-Object OtherComputerName,OtherComputer,AndAgain

or use -ExcludeProperty to remove named ones - but then there must be a least one -Property (position 0 doesn't have to be written out, simply use an asterisk for all)

$csv | Select-Object * -ExcludeProperty ComputerName

Sample output here exactly matching your requirements:

OtherComputerName OtherComputer AndAgain
----------------- ------------- --------
infra-852                       infra-99
infra-85          infra-44      infra-23
infra-8                         infra-10
infra-55          infra-8       infra-70
                  infra-852

Not a table but a single shrinked col:

$csv|select Othercomputer|where Othercomputer -ne ''

Sample output:

OtherComputer
-------------
infra-44
infra-8
infra-852

edited Jun 20, 2017 at 9:48

answered Jun 19, 2017 at 21:48

user6811411

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

14 Comments

charlo Over a year ago

When I exclude the column there still a big space between some cells. Is it possible to retire it ?

user6811411 Over a year ago

Append |Format-Table -auto

charlo Over a year ago

$csv | Select-Object * -ExcludeProperty ComputerName |Format-Table -auto like this ? If it is, it does nothing

user6811411 Over a year ago

The columns can't be smaller than the headings.

charlo Over a year ago

So, It is impossible to exclude cells which are matching with the first column ?

|

Ranadip Dutta · Accepted Answer · 2017-06-19 14:49:04Z

0

This should do your work:

$csv = Import-Csv .\test1.csv -Delimiter ';'

$ref = @($csv.ComputerName)
foreach ($row in $csv) {
  foreach ($col in 'OtherComputerName', 'OtherComputer', 'AndAgain') {
    if ($ref -contains $row.$col) { $row.$col = '' }
  }
}

$csv | Select-Object ComputerName , AndAgain

answered Jun 19, 2017 at 14:49

Ranadip Dutta

9,5923 gold badges33 silver badges48 bronze badges

Collectives™ on Stack Overflow

Display only the columns needed PowerShell

2 Answers 2

14 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

14 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related