Matching based on 2nd Character

[kauser]

Hello, 

is there any way to map a column based on 2nd character from other column 

Input file 1

Product

0AY

0BJ

0GW

0DL

Input file 2

2nd Character

A

B

C

D

Output file 

Product	2nd Character	YES/NO
0AY	A	YES
0BJ	B	YES
0GW	C	NO
0DL	D	YES

Third row is "NO" because 2nd character doesn't match between 1st and 2nd character. 

[kauser]

Third row is "NO" because 2nd character doesn't match between 1st and 2nd input files

[binuacs · Accepted solution]

@kauser one way