in reply to Sorting By Column

Your question is pretty hard to understand, to be honest. Maybe try to ask again, in a different way. Give some examples of this:
The trick is that the file has 90k+ entries and line 1 may have duplicates such as 'Scott' more than once which I would like to keep, only eliminating those values where 'Scott' shows in line key 1 & 2 of the same second column value
Your samples don't have any duplicates as far as I can tell.

Replies are listed 'Best First'.
Re^2: Sorting By Column
by Roguehorse (Initiate) on Jul 10, 2014 at 21:27 UTC

    You're right, there are no duplicates in the sample, however there ARE duplicates in the original file and thus only duplicates that share the same column 2 and column 3 value and are distinguished between key 1 and key 2 should be removed

    The idea is NOT to remove:

      1 23456 Scott
      2 23456 Stapp
      1 56789 Scott
      2 56789 Miller

    But DO REMOVE:

      1 76543 Miller
      2 76543 Miller
      1 33446 Scott
      2 33446 Scott

    Does this clarify the question a bit?

[reply]

In Section Seekers of Perl Wisdom