Remove Multiple Columns from CSV Using a Variable - Powershell

Question

I'm trying to figure out a way to pass a list of columns as a parameter to be excluded when importing a CSV file. I can get the code working when I explicitly list the columns, but want to be able pass in a parameter of the list of columns from the calling application so that I don't have to update the script each time more columns need to be excluded.

This of course works:

$NewCsv = Import-CSV $FileFullPath | Select * -ExcludeProperty user_id,first_name,last_name,email

But this doesn't work:

$removecolumns = "'user_id','first_name','last_name','email'"
$NewCsv = Import-CSV $AuraFileFullPath | Select * -ExcludeProperty $removecolumns

Nor this:

$removecolumns = "user_id,first_name,last_name,email"
$NewCsv = Import-CSV $AuraFileFullPath | Select * -ExcludeProperty $removecolumns

Or this:

$removecolumns = @('user_id','first_name','last_name','email')
$NewCsv = Import-CSV $AuraFileFullPath | Select * -ExcludeProperty $removecolumns

I'll keep digging but any suggestions would be most appreciated!

user2073183 · Accepted Answer · 2020-12-17 17:14:56Z

1

I ended up getting it working using

 $removecolumns = @('user_id','first_name','last_name','email')
$NewCsv = Import-CSV $AuraFileFullPath | Select * -ExcludeProperty $removecolumns

The application that calls the script and passes in @('user_id','first_name','last_name','email') as a parameter was the problem.

Thanks!

answered Dec 17, 2020 at 17:14

user2073183

1511 gold badge3 silver badges17 bronze badges

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

1 Comment

iRon Over a year ago

As a semantic sugar, you might remove the @ sign and parentheses: $removecolumns = 'user_id','first_name','last_name','email'

Collectives™ on Stack Overflow

Remove Multiple Columns from CSV Using a Variable - Powershell

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related