I created a regex that successfully captures a
string from a longtext column.
However, I'm having trouble using search & replace to copy it to another column. I tried this:
Instead of just 'M', as expected, it copied the entire contents of the column to #fanficrating, but replaced the matched part with 'M'.
What should I do?