Column Search and Line Removal

Shell Programming and Scripting
1

Hello Gurus,

I need to remove lines within a file if it contains specific criteria. Here is what I am trying to resolve:

Users of AppRuntime:  (Total of 10 licenses issued;  Total of 6 licenses in use)
    buih02 dsktp501 AppGui 1 (compute_lic/27006 3122), start Mon 2/22 7:58
    dingj1 compute57 AppGui 1 (compute_lic/27006 408), start Thu 2/25 15:47
    figuki compute67 AppGui 1 (compute_lic/27006 1303), start Wed 1/27 12:50
    flora8 dsktp601a AppGui 1 (compute_lic/27006 1609), start Thu 1/28 13:36
    kleckera compute23 AppGui 1 (compute_lic/27006 2607), start Tue 2/2 9:03
    knoxpk compute54 AppGui 1 (compute_lic/27006 1401), start Tue 1/19 19:25

I need to find and remove all occurrences of �compute� found from the second column only.

The results would be:

Users of AppRuntime:  (Total of 10 licenses issued;  Total of 6 licenses in use)
    buih02 dsktp501 AppGui 1 (compute_lic/27006 3122), start Mon 2/22 7:58
    flora8 dsktp601a AppGui 1 (compute_lic/27006 1609), start Thu 1/28 13:36

Any help would be greatly appreciated!
Thank you.

2

Try:

awk '$2 !~ /compute/' file
3

THANK YOU, Mr. Jacob!

That did the trick.

4

Dear Friend, you can use the following code also

consider the file contain the following content

Users of AppRuntime:  (Total of 10 licenses issued;  Total of 6 licenses in use)
        buih02 dsktp501 AppGui 1 (compute_lic/27006 3122), start Mon 2/22 7:58
        dingj1 compute57 AppGui 1 (compute_lic/27006 408), start Thu 2/25 15:47
        figuki compute67 AppGui 1 (compute_lic/27006 1303), start Wed 1/27 12:50
        flora8 dsktp601a AppGui 1 (compute_lic/27006 1609), start Thu 1/28 13:36
        kleckera compute23 AppGui 1 (compute_lic/27006 2607), start Tue 2/2 9:03
        knoxpk compute54 AppGui 1 (compute_lic/27006 1401), start Tue 1/19 19:25

cat file | sed -e '/compute[0-9]/d'

The output is

Users of AppRuntime:  (Total of 10 licenses issued;  Total of 6 licenses in use)
        buih02 dsktp501 AppGui 1 (compute_lic/27006 3122), start Mon 2/22 7:58
        flora8 dsktp601a AppGui 1 (compute_lic/27006 1609), start Thu 1/28 13:36