AWK script issue for the part regular expression

Shell Programming and Scripting
1

Hi I am having a file as shown below

FILE 1

TXDD00, TXDD01, TXDD02, TXDD03,
        TXDD04, TXDD05, TXDD06, TXDD07,
        TXDD08, TXDD09, TXDD10, TXDD11,
        TXDD12, TXDD13, TXDD14, TXDD15,
        TXDD16, TXDD17, TXDD18, TXDD19,
        TXDDCLK, TXDJTAGAMPL0, TXDJTAGAMPL1, TXDJTAGOE,
        TXDOE, TXEBSIN, TXED00, TXED01,
        TXED02, TXED03, TXED04, TXED05,
        TXED06, TXED07, TXED08, TXED09,
        TXED10, TXED11, TXED12, TXED13,
        TXED14, TXED15, TXED16, TXED17,
        TXED18, TXED19, TXEDCLK, TXEJTAGAMPL0,
        TXEJTAGAMPL1, TXEJTAGOE, TXEOE, TXFBSIN,
        TXFD00, TXFD01, TXFD02, TXFD03,
        TXFD04, TXFD05, TXFD06, TXFD07,
        TXFD08, TXFD09, TXFD10, TXFD11,
        TXFD12, TXFD13, TXFD14, TXFD15,
        TXFD16, TXFD17, TXFD18, TXFD19,
        TXFDCLK, TXFJTAGAMPL0, TXFJTAGAMPL1, TXFJTAGOE,
        TXFOE, TXGBSIN, TXGD00, TXGD01,
        TXGD02, TXGD03, TXGD04, TXGD05,
        TXGD06, TXGD07, TXGD08, TXGD09,
        TXGD10, TXGD11, TXGD12, TXGD13,
        TXGD14, TXGD15, TXGD16, TXGD17,
        TXGD18, TXGD19, TXGDCLK, TXGJTAGAMPL0,
        TXGJTAGAMPL1, TXGJTAGOE, TXGOE, TXHBSIN,
        TXHD00, TXHD01, TXHD02, TXHD03,

I need to delete the lines or the words carrying regular expression TXE , TXF , TXG and TXH

I am using below AWK script to delete the lines

awk '{for(i=1;i<=NF;i++) if ($i~/TXE/){ gsub(/TXE/," ",$i)} }1' FILE1 > HS.TEMP2

but it is not deleting the whole word matching the expression TXE for example TXEBSIN pin is becoming BSIN , it should delete the whole word matching the regular expression , how to do that ?

Thanks and Regards
Jaita

2

The regular expression in your substitution is just to replace the 3 characters:

gsub(/TXE/," "

It should be something like

gsub(/TXE[^,]/,""

An iteration through all fields should not be necessary.

If I got it right, you want to remove the words, not really the whole line(?), if they are mixed with strings that should be printed. An alternative:

sed -e 's/TX[EFGH][^,]*,//g' -e '/^[ \t]*$/d' file
TXDD00, TXDD01, TXDD02, TXDD03,
        TXDD04, TXDD05, TXDD06, TXDD07,
        TXDD08, TXDD09, TXDD10, TXDD11,
        TXDD12, TXDD13, TXDD14, TXDD15,
        TXDD16, TXDD17, TXDD18, TXDD19,
        TXDDCLK, TXDJTAGAMPL0, TXDJTAGAMPL1, TXDJTAGOE,
        TXDOE,
3 
awk '!/TX[EFGH]/' file
4 
grep -v TX[EFGH] infile