Trying to match a blank column in CSV with regex

[aman Participant Topics: 10 Replies: 11 Points: 145Rank: Participant]

Hello Everyone,

 

I am trying to match a blank column with regex in CSV and using below code but not returning anything for me. I can find blank column via where object but want to strictly use regex here for matching.

 
<p class=”p1″>Import-CSV -Path “C:\Servicess.CSV” | Where-Object {$_.Site -Match “\s+”} </p>
 

Thanks

 

 

[Matt Bloomfield]

\s+ matches 1 or more whitespace characters but you have an empty cell, not a cell with whitespace characters.  Try using ^$ to match an empty string.

• This reply was modified 1 month ago by Matt Bloomfield. Reason: Corrected Typo

[aman Participant Topics: 10 Replies: 11 Points: 145Rank: Participant]

That Worked, Thanks alot.

[Rob Simmers Participant Topics: 17 Replies: 1951 Points: 3,988Rank: Community Hero]

Another way without regex:

PowerShell

Import-CSV -Path “C:\Servicess.CSV” | Where-Object {[string]::IsNullOrEmpty($_.Site)}

1	Import-CSV -Path “C:\Servicess.CSV” | Where-Object {[string]::IsNullOrEmpty($_.Site)}

[aman Participant Topics: 10 Replies: 11 Points: 145Rank: Participant]

Thanks alot.

[Author]

Posts