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.