Shell Programming and Scripting

awk -F '   *| *; *' '
# Input field separator is (two or more spaces) or (semicolon and any adjacent
# [before or after the semicolon] spaces).
FNR == NR {
	# Process lines from 1st file...
	# Skip to next line if 1st field is not "RW"...
	if($1 != "RW")
		next
	# We have an RW line; grab keys and values from remaining semicolon
	# separated fields...
	for(i = 2; i < NF; i++) {
		# printf("line:%s, field:%d, %s\n", NR, i, $i)
		# The key comes before the 1st comma...
		if(match($i, /, */)) {
			# value follows spaces after the comma.
			k[s = substr($i, 1, RSTART - 1)] = \
				substr($i, RSTART + RLENGTH - 1)
			# printf("k[%s]=%s\n", s, k[s])
		}
	}
	next
}
{	# Process lines from 2nd file...
	# Print line along with value corresponding to key found in field 1...
	printf("%-34s %s\n", $0, k[$1])
}' File\ [12]

P9610     55.4.12.3     klskdls     AR_BSU , T
QI77      3.221.12.1    abcd        BC_RBR , T
P12       2.14.14.A     daswd       CI_KLN , ?
P24       1.4.56.43.1   dsadff      AR_ELI , T
P2G4      2.A.3.6.3     azfddaf     CA_SATI , F