delete a matched string in a condition, PowerShell

Question

the idea is to import a csv, and then if the value "infohostname" contains a nullorwithespace delete the entire line

    Function Last_NAS_Parse {

$Import_IP = Import-Csv -Path "$destination_RAW_NAS\audit_nas_8_$((Get-Date).ToString('yyyy-MM-dd')).txt" -Header @("date","infohostname","Version","SMTP","Value_1","Value_2","Value_3","Value_4","Value_5","Value_6","Value_7","Value_8","Value_9")
$Import_IP | ForEach-Object {
   if ( [string]::IsNullOrWhiteSpace($_.infohostname)


  }

But don't know how can i delete the line after this is selected, thanks.

Firstly, your code is missing parentheses and brackets in order to compile as posted. Is your goal to delete the entire row from the file, or simply clear it? — trebleCode
– trebleCode, Commented Nov 23, 2018 at 19:10
@trebleCode the idea is just to delete the entire row from the file — A.lacorazza
– A.lacorazza, Commented Nov 23, 2018 at 19:12

user6811411 · Accepted Answer · 2018-11-23 19:26:37Z

2

IMO you don't need a function just a Where-Object:

$Header = ("date","infohostname","Version","SMTP","Value_1","Value_2","Value_3","Value_4","Value_5","Value_6","Value_7","Value_8","Value_9")
$Import_IP = Import-Csv -Path "$destination_RAW_NAS\audit_nas_8_$((Get-Date).ToString('yyyy-MM-dd')).txt" -Header $Header | 
   Where-Object {![string]::IsNullOrWhiteSpace($_.infohostname)}

But of course you could wrap that in a function
(but a function without passed parameters and returned values isn't a real function)

answered Nov 23, 2018 at 19:26

user6811411

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

Comments

trebleCode · Accepted Answer · 2018-11-23 19:18:21Z

0

Loop over the results and store only objects where that boolean evaluation is true, and create a new file. In order to delete the row of the existing file, I believe you'd have to convert it to XLS/X and access it as a COM object

$results = @()
Function Last_NAS_Parse {

    $Import_IP = Import-Csv -Path C:\path\to\file.csv
    $Import_IP | ForEach-Object {
        if ( [string]::IsNullOrWhiteSpace($_.infohostname)) 
        {
            Out-Null
        }
        else
        {
            $results += $_
        }
    }
}

Last_NAS_Parse
$results | Export-CSV "C:\export\path\of\newfile.csv"

answered Nov 23, 2018 at 19:18

trebleCode

2,3382 gold badges25 silver badges36 bronze badges

Collectives™ on Stack Overflow

delete a matched string in a condition, PowerShell

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related