Hi,
I need to perform a grep from a file, but ignore any results from the first column.
For simplicity I have changed the actual data, but for arguments sake, I have a file that reads:
MONACO Monaco ASMonaco
MANUTD ManUtd ManchesterUnited
NEWCAS NewcastleUnited
NAC000 NAC NACBreda
The first column in this file will always contain a 6-character ID. This file is basically a lookup table where a grep is performed with the idea of returning the ID in the first column. There can be many aliases for each ID, as you can see above.
The problem I have is that sometimes I get 2 IDs returned. For example, when I grep for 'NAC', with the aim being to return the ID 'NAC000', but this grep also matches the ID for the MONACO line.
Is there any way to grep, but ignore any matches from the first column? Or perhaps grep only from column 2, or 3 etc etc?
Thanks.