Delete all files if another files in the same directory has a matching occurence of a specific word

Question

I have several files in a specific directory. A specific string in one file can occur in another files. If this string is in other files. Then all the files in which this string occured should be deleted and only 1 file should remain with the string.

Example:

file1
ShortName "Blue Jeans"
price 89.47
cur EURO

file2
ShortName "Blue Jeans"
Price 59.47
CUR USD

file3
ShortName "Blue Jeans"
Price 99.47
CUR GBP

Since the value of ShortName "Blue Jeans" is occuring in file2 & file3. Both this file should be deleted. Similarly files with other ShortName Could any one please help me how can it done via script (ksh, SED, AWK). I am on solaris.

Thank you

Answer 1

gawk solution only for these 3 files, since no other information provided at time of writing

awk 'FNR==NR && FNR==1{ get=$0; next}
FNR!=NR && FNR==1 && $0 ~ get{ 
 cmd="rm \047"FILENAME"\047"
 print cmd
 # system(cmd) #uncomment to use 
}' 1.txt 2.txt 3.txt

Answer 2

This script finds all duplicates and leaves only one example of each. For example, let's say there are three "Blue Jean" files, two "Plaid Shirt" files, one "Sneakers" file and several files with no "ShortName". After running this script, you should have one each: "Blue Jeans", "Plaid Shirt" and "Sneakers" and the other files should be untouched. Price and currency are completely ignored.

Paranoid disclaimer: This is ugly and guaranteed to blow up. Caveat emptor. No refunds.

#!/bin/bash
dir="apparel"
saveIFS="$IFS"
IFS=$'\n'
strings=($(sed -n 's/ShortName "\(.*\)"/\1/p' ${dir}/*|sort|uniq -c))    # dummy comment to fix syntax coloring (ignore me) */
IFS="$saveIFS"
for string in "${strings[@]}"
do
    count=${string:0:7}
    count=${count// }
    string=${string:8}
    if [[ $count > 1 ]]
    then
        first=1
        for f in $(grep -l "$string" ${dir}/*)                           # dummy comment to fix syntax coloring (ignore me) */
        do
            if [[ $first ]]
            then
                unset first
            else
                echo rm "$f"
            fi
        done
     fi
done

Remove the echo after you've tested it to make the rm work.