Replacing data in a csv from "" to "null" powershell

Question

I am reading a CSV in a powershell script. The script pulls specific data, and then writes it to a different CSV. Is there a way I can replace any "" values with the word "null"?

BartekB · Accepted Answer · 2012-05-22 18:16:08Z

3

I think that should give you something to start with...:

@'
Foo,Bar
"",""
Alfa,Beta
Gamma,""
"",Delta
'@ | ConvertFrom-csv | Foreach-Object { 
    foreach ($Property in $_.PSObject.Properties) {
        if ([string]::IsNullOrEmpty($Property.Value)) {
            $_.($Property.Name) = 'NULL'
        }
    }
    $_
} | ConvertTo-Csv -NoTypeInformation

You could try just replace: "" with "NULL", but if you have more complicated data it may give you some unexpected results, working on PSObject.Properties collection does not have this flaw/ risk.

answered May 22, 2012 at 18:16

BartekB

8,71034 silver badges33 bronze badges

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

1 Comment

Michael Sorens Over a year ago

Thanks for revealing the PSObject; was not aware of that. Do you happen to have any links to articles discussing PSObject? Neither a quick web search nor the PowerShell spec was terribly fruitful.

Collectives™ on Stack Overflow

Replacing data in a csv from "" to "null" 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