How to omit empty strings in output

Question

I'm splitting a csv on the comma and taking the 6th cell:

Get-Content .\BSEG_EXPORT.csv | foreach { $_.Split(",")[6] }

However, this returns a lot of empty strings (no match on the current line):

""
""
"something" 
""
""

How can I ommit the "" in my output? So:

"something"

I tried

Get-Content .\BSEG_EXPORT.csv | foreach { $a = $_.Split(",")[6] } | Where { $a -ne "" }

but this does not work.

arco444 · Accepted Answer · 2015-02-24 11:48:37Z

1

What about:

Get-Content .\BSEG_EXPORT.csv | foreach { 
  $cell = $_.Split(",")[6] 
  if ($cell -ne '""' ) { write-output $cell }
}

answered Feb 24, 2015 at 11:48

arco444

23k12 gold badges66 silver badges67 bronze badges

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

2 Comments

Pr0no Over a year ago

Thanks, but trying this on the commandline (Get-Content .\BSEG_EXPORT.csv | foreach { $cell = $_.Split(",")[6] if ($cell -ne "") { Write-Host $cell } }) gives me an error: Unexpected token if. I can probably put it in a .ps1 and it'll work, but how do I formet this for the command line?

arco444 Over a year ago

add a semi colon between the $cell assignment and the if if you're doing it all on one line: $cell = $_.Split(",")[6] ; if ($cell ...) {... }

mjolinor · Accepted Answer · 2015-02-24 11:59:49Z

1

Try it this way:

Get-Content .\BSEG_EXPORT.csv | foreach { $_.Split(",")[6] -ne '""'}

answered Feb 24, 2015 at 11:59

mjolinor

68.7k7 gold badges118 silver badges141 bronze badges

Collectives™ on Stack Overflow

How to omit empty strings in output

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related