title: Remove leading and trailing chacters for hive column
body: <p>I have a hive column which has unknow numbers of leading and trailing double quotes in column.The column has double quotes inside data as well.</p>
  <p>For example column looks like this</p>
  <p><a href="https://i.stack.imgur.com/YYoqW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YYoqW.png" alt="enter image description here" /></a></p>
  <p>I want output like below</p>
  <p><a href="https://i.stack.imgur.com/Wsi3f.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Wsi3f.png" alt="enter image description here" /></a></p>
  <p>I have written a pyspark code where I can just strip the &quot; and it works,but I want a solution in hql.
  I have also tried regexp_replace like</p>
  <pre><code>regexp_replace(test,'^&quot;|^&quot;&quot;|&quot;&quot;$|&quot;$', &quot;&quot;)
  </code></pre>
  <p>but this is kind of hardcoding.
  Can someone please provide a generic solution for this?</p>