Hello, is there any way to map a column based on 2nd character from other column Input file 1 Product 0AY0BJ0GW0DL Input file 2 2nd Character ABCD Output file Product 2nd Character YES/NO0AYAYES0BJBYES0GWCNO0DLDYES Third row is "NO" because 2nd character doesn't match between 1st and 2nd character.

Matching based on 2nd Character

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

Output file

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

Developer

@kauser one way

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

@kauser one way