REGEX search & replace with sed or other command

Question

I have a big SQL file with content like

[code language="bash"]
git checkout master
git pull origin master
...
[/code]
Lorem ipsum dolor sit amet, consectetur adipiscing elitUt enim ad minim 
[code]some other code[/code]
veniam, quis nostrud exercitation
[code language="php"]var_dump($data);[/code]

And I want to replace the [code language="{lang}"]{wrapped-code}[/code] by <pre><code class="language-{lang}">{wrapped-code}</code></pre>

So the final output will look like

<pre><code class="language-bash">
git checkout master
git pull origin master
...
</code></pre>
Lorem ipsum dolor sit amet, consectetur adipiscing elitUt enim ad minim 
<pre><code>some other code</code></pre>
veniam, quis nostrud exercitation
<pre><code class="language-php">var_dump($data);</code></pre>

Please let me know how we can achieve this with sed or other find and replace command.

Answer 1

sed -e 's/\[code language="\([^"]*\)"\]/<pre><code class="language-\1">/' \
    -e 's!\[/code\]!</code></pre>!' \
    < input  > output

The square brackets have to be escaped so that they don't represent a set of characters; I then capture the text between the quotes to use in the replacement (as \1); for the second search & replacement, I used ! as the separator to avoid Leaning Toothpick Syndrome with the HTML end-tag replacements.