Need PowerShell script to filtering the excel data

Question

I am trying to filter the data contains in excel. but it showing error.

Import-Csv -Path "D:\Excel\Data\List.csv" -Header "EventID", "TimeCreated", "Computer", "TargetUserName", "SubjectUserName", "HOSTName", "Filename" | 
        Where-Object {[INT]$_.TargetUserName -eq 122388} | 
        Select-Object "EventID", "TimeCreated", "Computer", "TargetUserName", "SubjectUserName", "HOSTName", "Filename" | 
        Export-Csv "D:\Excel\test.csv" -NoTypeInformation

By using the -header parameter you adding an extra header to the already existing header. Therefore the existing header becomes the first row where the top cell in the TargetUserName contains the string "TargetUserName" which can't be converted to an integer. Long story short: lose the -header parameter. — iRon
– iRon, Commented Jun 24, 2022 at 7:00
Additional note: the operand at the left hand side in a comparison operation is leading for type casting. In other words, by simply swapping the operands (122388 -eq $_.TargetUserName) you will do a number (integer) compare. — iRon
– iRon, Commented Jun 24, 2022 at 7:09

Toby Boulton · Accepted Answer · 2022-06-24 05:39:44Z

1

It's likely getting read in as a string instead of an integer. Do an equality test against a string instead.

Try replace Where-Object {[INT]$_.TargetUserName -eq 122388} with Where-Object {$_.TargetUserName -eq "122388"}

edited Jun 24, 2022 at 5:39

answered Jun 24, 2022 at 5:33

Toby Boulton

1903 silver badges11 bronze badges

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

2 Comments

Arunkumar Over a year ago

How to do the equality test. I am new for the shell scripting. kindly help me @Toby Boulton

Toby Boulton Over a year ago

@Arunkumar check updated answer

Collectives™ on Stack Overflow

Need PowerShell script to filtering the excel data

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