PowerShell DataTable delete column containing value "description"

Question

I would like to delete all empty rows from the DataTable below as well as delete the column containing the value "description". I am able to delete all empty rows; however, I can't figure out how to also explicitly delete description from the DataTable.

Original DataTable:

dev_id              : 4721
office_id           : 355
name                : Bobby
ip                  : 10.10.10.1
ipv6                : 2001:1930:ff28:ff00::1
mac                 :
serial_num          : XX234555
platform            : Supercode
                    :
description         : I;need;to;delete;this;
                    :  
                    : 
max_speed           : 100000

Code:

$myreader = $mycommand.ExecuteReader()
$DevicesDataTable.Load($myreader)
$myconnection.Close()

$Columns = $DevicesDataTable.Columns.Count
$Rows    = $DevicesDataTable.Rows.Count

for ($r = 0; $r -lt $Rows; $r++) {    
    $Empty = 0
    for ($c = 0; $c -lt $Columns; $c++) {

        if (($DevicesDataTable.Rows[$r].IsNull($c)) -or ($DevicesDataTable.Rows[$r].Equals("description"))) {
            $Empty++
        }
    }
    if ($Empty -eq $Columns) {
        $DevicesDataTable.Rows[$r].Delete()
    }
}
# Delete
$DevicesDataTable.AcceptChanges()

Write-Output $DevicesDataTable

Result:
Note DataTable below still shows description:

dev_id              : 4721
office_id           : 355
name                : Bobby
ip                  : 10.10.10.1
ipv6                : 2001:1930:ff28:ff00::1
serial_num          : XX234555
platform            : Supercode
description         : I;need;to;delete;this;
max_speed           : 100000

Note: I am able to identify the column containing "description", however, I'm not sure how to delete the respective row via the correct method:

if ($DevicesDataTable.Columns[$c].ColumnName.Equals("description"))

Please clarify your intent: Are you trying to unconditionally remove the column named description from the table as a whole? — mklement0
– mklement0, Commented Aug 9, 2022 at 22:53
Yes. I dont want 'description' to be in the modified datatable. I want it unconditionally removed. — MKANET
– MKANET, Commented Aug 9, 2022 at 23:33

Mathias R. Jessen · Accepted Answer · 2022-08-10 09:12:13Z

1

You can drop a column from the data table by calling Remove() on the Columns collection:

$DevicesDataTable.Columns.Remove('description')

answered Aug 10, 2022 at 9:12

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

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

Collectives™ on Stack Overflow

PowerShell DataTable delete column containing value "description"

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related