Refrence File replace (awk)

Shell Programming and Scripting
1

I know lot of very similar questions have been asked multiple time before ... this is a bit different
Want to replace columns/subcolums from the reference file , if not present in the refrence file leave it as
it is
the complete column does not need to match the refernce file , values within a column also need to be checked .
for example if the column $3 is 10000000c9613e42_10000000c9613f44 , both these values need to be checked .

Input File

 
`1211,03G:1_12G:1,10000000c9613e42,BL_db00m02d
`1212,03G:1_12G:1,10000000c9613e42_10000000c9613f44,BL_db00m02d
`0DFE,03H:0_12H:0,10000000c974297f_10000000c9742a1a_10000000c9742aa6_10000000c9742ab6,BC_mq00m10_11
`1B02,03H:0_12H:0,10000000c974297f_10000000c9742a1a_10000000c9742aa6_10000000c9742ab6,BC_mq00m10_11

Refrence File

10000000c9613e42,10000000c9613e42(*)
10000000c9742a1a,10000000c9742a1a(*)
10000000c9742aa6,10000000c9742aa6(*)
10000000c9742ab6,10000000c9742ab6(*)

Output file

 
`1211,03G:1_12G:1,10000000c9613e42(*),BL_db00m02d
`1212,03G:1_12G:1,10000000c9613e42(*)_10000000c9613f44,BL_db00m02d
`0DFE,03H:0_12H:0,10000000c974297f_10000000c9742a1a(*)_10000000c9742aa6(*)_10000000c9742ab6(*),BC_mq00m10_11
`1B02,03H:0_12H:0,10000000c974297f_10000000c9742a1a(*)_10000000c9742aa6(*)_10000000c9742ab6(*),BC_mq00m10_11

Thanks !

2

Try:

nawk -F"," 'NR==FNR{a[$1]=$2;next}{for (i in a) gsub(i,a,$0)}1' ref input
3

Try

awk 'NR==FNR {REF[$1]=$2; next} {for (X in REF) gsub (X, REF[X])} 1 ' FS="," file2 file1
`1211,03G:1_12G:1,10000000c9613e42(*),BL_db00m02d
`1212,03G:1_12G:1,10000000c9613e42(*)_10000000c9613f44,BL_db00m02d
`0DFE,03H:0_12H:0,10000000c974297f_10000000c9742a1a(*)_10000000c9742aa6(*)_10000000c9742ab6(*),BC_mq00m10_11
`1B02,03H:0_12H:0,10000000c974297f_10000000c9742a1a(*)_10000000c9742aa6(*)_10000000c9742ab6(*),BC_mq00m10_11