Text file data analiyst

Welcome Forums General PowerShell Q&A Text file data analiyst

This topic contains 1 reply, has 2 voices, and was last updated by

 
Participant
1 year, 5 months ago.

  • Author
    Posts
  • #77112

    Participant
    Points: 0
    Rank: Member

    Hello everyone!
    I have a very large text file with well over 1 million lines in it that I need to do some data analyst on.
    What I need to accomplish is take this data file and get the data from the lines where the text in column 2-3 contains "NN" or"nn"
    Then from that sub set I need to get the values from columns 38-56 and 167-185.
    I then need to remove any duplicated that are found in the 167-185 columns.
    I then need to compare what remains from the 167-185 columns to the data from the 38-56 columns and return the values from that data set where there are no matches or null data.

    I have been poking around the net for a place to start but so far I am coming up short and I have very little time to get this done so I am hoping the the PS community can help me out.

    Thanks a bunch!!!!!

  • #77248

    Participant
    Points: 420
    Helping Hand
    Rank: Contributor

    A sample or a part of the text file could be helpful and of course the code you have so far.

The topic ‘Text file data analiyst’ is closed to new replies.