PowerShell - How to add content to specific cell in CSV File

Question

I'd like to seek your help on how to add content to a specific cell in a CSV file that is already with populated data, here's an example of my CSV file: CSV File with populated data

Here's an example of what I want to achieve:

UPN	Skype?	TV?	Whiteboard?	Description
room1	true	true	true	Skype; TV; Whiteboard
room2	true	false	false	Skype
room3	false	true	true	TV; Whiteboard

If room1 has Skype, TV, and Whiteboard, then to create the description with these values. If any of these are false, skip them. Does it make sense?

How can I achieve this using PowerShell?

This is what I've got so far:

Import-Csv $MeetingRooms | ForEach-Object {
    # Description field on Column Number 19
    $col = 19

    if ($_.Skype -eq $true) {
        $var = 'Skype for Business;'
        Add-Content -path $_ -Value "$(","*$col)$var"
    }elseif ($_.TV -eq $true) {
        $var = 'TV;'
        Add-Content -path $_ -Value "$(","*$col)$var"
    }elseif ($_.Whiteboard -eq $true) {
        $var = 'Whiteboard;'
        Add-Content -path $_ -Value "$(","*$col)$var"
    }
}

I am missing something big here which clearly can't see.

Thank you very much, Gonzalo

mklement0 · Accepted Answer · 2021-03-29 02:47:31Z

1

The following assumes that the column with index 19 is named CurrentFacilities.

Import-Csv $MeetingRooms | ForEach-Object {
  $obj = $_
  $obj.CurrentFacilities =
    ($obj.CurrentFacilities -split ';\s*') +
    ('Skype', 'TV', 'Whiteboard').Where({ $obj.$_ -eq 'true' }) -join '; '
  $obj # Output the modified object.
}

edited Mar 29, 2021 at 2:47

answered Mar 29, 2021 at 1:56

mklement0

453k68 gold badges729 silver badges989 bronze badges

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

Collectives™ on Stack Overflow

PowerShell - How to add content to specific cell in CSV File

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