Shell Programming and Scripting

When RudiC says he doesn't understand clearly what you are trying to do, that is an indication that your specification is not clear.

I also think we need a better specification of what is to be removed when $3 is not an empty field. If $3 is A, should every subfield in $6 be removed or will $3 always contain a letter and a number? If a number is always present, should subfields matching that string be removed, or just strings that start with the same letter and the same number? (For example, if $3 contains A1 should it remove a subfield that starts with A12 or just subfields that are A1 or start with A1-? If $3 contains A5 should all subfields of $6 containing A5 be removed (such as A1-A5 and A49-A51, or should it just remove subfields that are A5 or start with A5- or end with -A5?)

True, it was not clear at all, A1 can stands for A12 [learn that while using sed lol ], which in this case is a false positive., just like selecting A5; removing A51. I saw the post of RudiC, and it is in fact what I was trying to achieve.
@RudiC
what does

Code:

(t ~ $3)

stands for, I know that its a reference to field $3, but why the "~" ?
Yes indeed.
Thank you both for helping me.

That's awk's matching operator (man awk!). read: (t matches / contains $3), e.g. "A1-A4" matches / contains "A1" but wouldn't "A2". You could "sharpen" (narrow, restrict) the match with e.g. word boundaries like \b, \<, or \> (these may not be available in ALL regex engines): "A12-A14" ~ "\bA1\b" will yield FALSE.