Welcome Forums General PowerShell Q&A Select Single Column Using Index or Name – Import-CSV

Viewing 2 reply threads
  • Author
    Posts
    • #172513
      Participant
      Topics: 13
      Replies: 42
      Points: 243
      Rank: Participant

      For processing a huge file, I’d like to only import the third column. I don’t want to read the entire file into memory first and pipe it to Select name

      Is there a way for me to specify the index of the column(s) I want? For instance, if I wanted the second column, I’d tell it that I wanted index 1.

      If not, what’s the best way to deal with large files that are so big that you run out of RAM reading them in? Is the best method Get-Content | ConvertFrom-CSV? I’m only against that method because of how long it takes. Compared to a simple Import-CSV, it takes at least twice as long. But in cases where Import-CSV can’t be used, is it the best option?

    • #172582
      Participant
      Topics: 10
      Replies: 119
      Points: 537
      Helping Hand
      Rank: Major Contributor

      I realize you’re wanting to avoid reading the entire file and pipe to Select-Object, but have you considered using .NET directly with one of the [System.IO.File]:Read* static methods to speed up the read without the overhead of cmdlets? I’ve seen a similar solution in C# and perhaps you may need to look in that direction.

    • #172594
      Participant
      Topics: 2
      Replies: 512
      Points: 1,310
      Helping Hand
      Rank: Community Hero

      I think a better way to go is to work with the System.IO.StreamReader objects. You can read a line at a time, strip it down to the column you want, and move to the next line.

      But yeah, there’s no PowerShell-made support for this, as far as I’m aware.

Viewing 2 reply threads
  • The topic ‘Select Single Column Using Index or Name – Import-CSV’ is closed to new replies.