Shell Programming and Scripting

10001010G1
10001010G1
10001010G1
10001010G2
10001010G3
10001012G1
10001012G1
10001012G1
10001012G1
10001014G1
10001014G1
10001014G2

Value 10001010 has different code G1 G2 G3
Value 10001014 has different code G1 G2

Not errors found

#!/bin/bash

declare -A array

while read line
do
    case "${array[${line:0:8}]}" in
        *${line:8:2}*)
            ;;
        *)
            array[${line:0:8}]="${array[${line:0:8}]} ${line:8:2}";;
    esac
done

for val in "${!array[@]}"
do
    if [[ ${array[$val]} == \ *\ * ]]
    then
        echo Value $val has different code ${array[$val]}
        found=1
    fi
done

[[ -z $found ]] && echo Not errors found

script.sh <inputfile

{
    val = substr ($1, 1, 8);
    cod = substr ($1, 9, 2);

    if (index (array[val], cod) == 0) array[val] = array[val] " " cod;
}

END {
    for (val in array)
        if (match (array[val], " .* .*"))
        {
            print "Value " val " has different code" array[val];
            found=1
        }

    if (found == 0) print "Not errors found"
}

awk -f script.awk <inputfile

cat *.xls* > database

database

awk -f script.awk *.xls

cat *.xls | tee database | awk -f script.awk