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, 9 months ago.

  • Author
    Posts
  • #77112

    Participant
    Topics: 13
    Replies: 25
    Points: 28
    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
    Topics: 1
    Replies: 1323
    Points: 1,643
    Helping Hand
    Rank: Community Hero

    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.

denizli escort samsun escort muğla escort ataşehir escort kuşadası escort