PowerShell: Import-csv and output values to log file (formatting)

Question

I'm using the following to import users from a csv file and output them to the console:

$(Import-csv $SelectedFile | Select -ExpandProperty EmailAddress)

This displays each EmailAddress on a separate line in the console but I want to output this to a log file too.

Using the following will do this but not a separate line for each EmailAddress like the above. Instead it just shows them on one line with no separator:

"$(Import-csv $SelectedFile | Select -ExpandProperty EmailAddress)" | Tee-Object $UserMigrationLog -Append

Is it possible to do what I ask within this one command?

Martin Brandl · Accepted Answer · 2017-09-19 09:49:47Z

3

You interpolate the result of Import-CSV into a single string. Just remove the subexpression "$()" and it will work:

Import-csv $SelectedFile | Select -ExpandProperty EmailAddress | Tee-Object $UserMigrationLog -Append

answered Sep 19, 2017 at 9:49

Martin Brandl

59.4k16 gold badges151 silver badges190 bronze badges

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

2 Comments

jshizzle Over a year ago

Oh right. As simple as that! Excuse my ignorance but why does removing the subexpression change this?

Martin Brandl Over a year ago

Using a subexpression $() within a string "" will cast the result of that subexpression to a single string

Collectives™ on Stack Overflow

PowerShell: Import-csv and output values to log file (formatting)

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related