Powershell csv files and conditional statements

Question

I am relatively new to scripting and have been trying to solve a particular script problem in powershell, I am having difficult in exporting the output to a csv file, the script runs fine when displaying to the console but i either get string lengths or content relaring to the script. I am missing something with changing properties to content but cant seem to workout how to do it Many thanks in anticipation

import-csv "C:\scripts\test1\data-Raw.csv"|
foreach{ 
if ($_.Hide -eq 'True') { @{OutFinal=$_.OT_Pre,$_.extension}}
if ($_.Hide -eq 'False') { @{OutFinal=$_.extension,$_.extension}}
} | Export-Csv -NoTypeInformation "C:\scripts\test1\data-2.csv"

Esperento57 · Accepted Answer · 2017-02-26 11:00:54Z

2

try to convert in pscustomobject like this

import-csv "C:\scripts\test1\data-Raw.csv"|
foreach{ 
if ($_.Hide -eq 'True') { [pscustomobject]@{OutFinal=$_.OT_Pre;Extension=$_.extension}}
else { [pscustomobject]@{OutFinal=$_.extension;Extension=$_.extension}}
} | Export-Csv -NoTypeInformation "C:\scripts\test1\data-2.csv"

or simply like it:

import-csv "C:\scripts\test1\data-Raw.csv"|
foreach{
    [pscustomobject]@{
    OutFinal=if ($_.Hide -eq 'True'){$_.OT_Pre} else {$_.extension}
    Extension=$_.extension
    } 
} | Export-Csv -NoTypeInformation "C:\scripts\test1\data-2.csv"

if you want keep all property and add property you can do like it:

import-csv "C:\scripts\test1\data-Raw.csv"|
    select *, @{Name="OutFinal"; Expression={if ($_.Hide -eq 'True'){$_.OT_Pre} else {$_.extension}}} |
        Export-Csv -NoTypeInformation "C:\scripts\test1\data-2.csv"

edited Feb 26, 2017 at 11:00

answered Feb 26, 2017 at 9:51

Esperento57

17.6k6 gold badges42 silver badges47 bronze badges

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

1 Comment

Yetti Over a year ago

Thanks the first soltion seems to overcome my issue as a sidenote how would i include the other fields in the source csv file to the output i have tried combinations of $_. etc but i feel i dont fully understand this component in scripting yet

Collectives™ on Stack Overflow

Powershell csv files and conditional statements

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