title: Rails: how to split string after a specific character
body: <p>I have a column <code>name</code> in database which holds strings like <code>CVM&amp;#8482;</code> what I want to do is to split it so everything after ampersand goes into a different column and everything before the string stays where it was. The final result should put <code>&amp;#8482;</code> into a column called <code>abbr</code> and save <code>CVM</code> into <code>name</code> column.</p>