Shell Programming and Scripting

Hello,
I have a huge file with over 700,00 SNPs with 18 columns. One column is in the format

Code:

--+-+
---++
?????
-????

Now i have another list which corresponds to this code in a particular order

Code:

A-1
B-7
C-11
D-3
E-100

Now I need to match the expression above to the pattern, where +/- corresponds to A-E and ? corresponds to 0 and as an output I need to get a number.

So the output should be

Code:

--+-+ = 122  (because 1+7+11+3+100)
---++= 122
?????= 0
-???+= 101

This is just a sample, the numbers are much bigger and the pattern runs upto 24 times. Is there any way I can do it with bash scripting ?
Thank you

Something like

Code:

awk     'NR==FNR        {V[NR]=$2;next}
                        {sum=0
                         for (i=1; i<=NF; i++) sum+=($i=="?")?0:V[i]
                         print $0 " = " sum}
        ' FS="-" file1 FS="" file2
--+-+ = 122
---++ = 122
????? = 0
-???? = 1

(Doesn't match your sample output as that doesn't match your input file)