Hi all,
my table looks like this,
I.D allele
1 AA
2 AA
3 AA
4 AA
5 AA
6 AA
7 AT
8 AA
i want to found different allele (AT) from allele column and store it in 3rd column
i am expecting like this
I.D ALLELE RESULT
1 AA MATCH
2 AA MATCH
3 AA MATCH
4 AA MATCH
5 AA MATCH
6 AA MATCH
7 AT NOT MATCH
8 AA MACTH
how can i do this? is regular expressions and loops will work for me to solve my problem?, please suggest me in this,
Thanks in advance
Regards,
GENTIST