Reverse-complement string of DNA

I made a basic Revcom formula to reverse-complement strings of DNA:

replace(
replace(
replace(
replace(
replace(
replace(
reverse(lower(‘ATGC’)),
‘a’,‘X’),
‘t’,‘a’),
‘X’,‘t’),
‘c’,‘Y’),
‘g’,‘c’),
‘Y’,‘g’)

Probably not the most elegant implementation but it works!
Useful for biotech community.

1 Like

Thanks for sharing @FrancoisS, we appreciate it a lot :raised_hands: