Text file data analiyst

This topic contains 1 reply, has 2 voices, and was last updated by  Olaf Soyk 1 week ago.

  • Author
    Posts
  • #77112

    Nathan W
    Participant

    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

    Olaf Soyk
    Participant

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

You must be logged in to reply to this topic.